Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am not sure weather this is possible or not.
I have simple data load and I have created table in Qlikview document. I would like to take a snapshot of table numbers and save it on each day. like below.
Yesterday
Today
I would need result as below ( Its fine if its create new Qlikview file or new separate table )
Data | CAO | CPR | PhAO | PhPR | MTCH | MTPP | MTCH | MTP | Date |
Studio Data | 3 | 5 | 82 | 9 | 8 | 9 | 11 | 10 | 29-Nov-17 |
Studio Data | 52 | 5 | 41 | 9 | 13 | 9 | 11 | 0 | 30-Nov-17 |
You can at script level
Thanks can you share me example please 🙂
Hi,
you can make this:
before your LOAD:
Let vToday = DATE(Today(),'DDMMYYYY');
after your LOAD:
store TABLE into 'PATH\TABLE_$(vToday)' (txt);