Discussion board where members can get started with Qlik Sense.
Please help me in the below query.. Is it possible to calculate the running total after loading the data in qvd not in visualization.
I need a running total on the basis of ALID.. which can be filter on CA, MA & DA.
Please help me. I need an urgent help!!
Hello Sir... I just wanted to know if the above query is possible or not.
Attached is the file.. This is the QVD data.. In the visualization I need only three columns..
Monthyear, Actual ALID and Cumulative ALID... It would be great if u can help me.
Sir somehow in my Qlik Sense desktop QVW file is not showing any sheets.
Can you please help me out to post a Qvf or qvd file calculating the running total on the above sheet..
Thanks a ton in advance..
i dont have Sense installed in this machine so i proceed by copying loading script and expressions.
YEAR(PGLD) * 100 + MONTH(PGLD) AS PERIOD
LOAD DATE(PGLD) as PGLD,
ALID FROM [YourFile] (ooxml, embedded labels, table is Sheet1);
Hope one of this versions helps you.