Qlikview , How to recover lost hidden script

Refer จาก : https://www.youtube.com/watch?v=Gt6vIvjtY74


สมมุต App อยู่ C:\QV\App01.qvw

ให้สร้าง Folder --> C:\QV\App01-prj ขึ้นมา คือให้ล้อตามชื่อ App แต่ต่อท้ายด้วย -prj

เปิด App01.qvw ขึ้นมา แล้วกด Save
เปิด Folder App01-prj จะเจอ Source file ทั้งหมด
หา File DocBinary.dat แล้วลบทิ้ง
จากนั้นเปิด App01.qvw ขึ้นมาใหม่ แล้วทำการสร้าง Hidden Script ใหม่

เคสนี้ควรมี Back up script ของตัว Hidden ไว้ด้วย เพื่อสามารถ Copy มา Paste ได้เลย

Qlikview set analysis , Between two values

=

//SUM({<FactAll.RSTrakingDaySEQ={$(vRS_TrackingDaySEQ)}  >} $(vMeasures01Value))
//SUM({<FactAll.RSTrakingDaySEQ={">=$(vRS_TrackingDaySEQ)<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))
SUM({<FactAll.RSTrakingDaySEQ={">=1<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))


ข้อห้ามมมม ห้ามมี Space ระหว่าง >= <= เด็ดขาด จะทำให้ผลลัพธ์ผิด
" " Space is cause to error result! Pls eliminate it from {}

Qlikview Chart property is gone! or missing (Solved)

Some time Qlikview wasn't response.
Example I create a chart and adding/adjust some expression and then I click "OK"
The dialog disappear! But It seem the dialog still there! What happen then.
I can do nothing with that screen.
I try to close the others running program ,switch application but have no luck.
Searching in Google still not found any one who have this problem.

AND THEN I realize that I've not try to use the key board key.
So this problem was solved by Press Ctrl+S to save the file and then End task Qlikview.

For better save your ass is to Press Ctrl + F12 (Save as a new file)
Because I've facing some kind of problem that more seriously ,File damaged after saving.
Size of file decrease to 0 KB .
Good luck buddy!

X axis problem when using Linest_M function

AGGR & LINEST_M function


Thank you to https://community.qlikview.com/thread/115111

SOLVED by using : aggr( rowno(), yearmonth))

The trendline formula uses the index number of the x-axis dimension values, i.e the left most value is 1, the next 2 etc. The linest_m function uses the actual x-axis dimension values. You could try:

linest_m(aggr( sum(....vSold...)/sum(....Quantita...) , yearmonth), aggr( rowno(), yearmonth))

See attached example.

How to add qlikview user cal (License)

- Open QV Management console
- Click tab "System"
- Select "Qlikview Server"
- Select sub tab "License"
- Select Client Access License (CALs)
- Select Assigned CALs

Allocated Memory Exceeded - QV11 | Qlik Community

https://community.qlik.com/thread/41825

Bug in QV 11

-Try to create a new chart instead of copy from the old one.

Qlikview , Set analysis greater than ,">="

Syntax

SUM(
{ < Calendar.Date = {">=$(=FLOOR(NUM(NOW()-30)))"} >}

FactAll.Fee)

// Sum of last 30 days ">="