Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
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!!
Thanks
Hi,
maybe there's something wrong with your attachment since it doesn't seem to be any.
Please verify in order to help you.
Kind regards,
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.
Please guide
Thanks
Hello sir
Please find the attached file
On Oct 26, 2016 12:44 AM, "Santiago Respane" <qcwebmaster@qlikview.com>
Can you also post your expected output!
Hi!
now i can se attached.
What do you mean by actual? current day? Month?
Kind regards,
Vinnet & Santiago Sir
Please see the attached snapshot..
I need to show in this way..
Please let me know if it is making sense or not
Please help. Thanks
Hi,
Please find attached one of many possible solutions.
Kind regards,
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..
Hi,
i dont have Sense installed in this machine so i proceed by copying loading script and expressions.
TEST:
LOAD *,
YEAR(PGLD) * 100 + MONTH(PGLD) AS PERIOD
;
LOAD DATE(PGLD) as PGLD,
CLN,
DIN,
MAN,
ALID FROM [YourFile] (ooxml, embedded labels, table is Sheet1);
Hope one of this versions helps you.
Kind regards,