Discussion Board for collaboration related to Creating Analytics for QlikView.
I need some help and am not sure if I shall use flags or some other practical solution exists. Either ways, I need your advice teaching me how to do it please.
I need to see most recent 3 days' sales in product breakdown and additionally, I would like to see the same for 7 days earlier. I may need to have most recent 3 days and -7 days adjusted based on my selections (or might not need, am not sure yet).
This is what I would like to do with QlikView :
Attached is the qvw file for your easy reference. (table is in the inline script, no tab elements)
Any advice would be greatly appreciated.
Have a look at the attached file.
Hi Kaushi Solanki,
Thanks for your kind help.
Is there a way that I can show only last 3 days and 7 days earlier data only? If you refer to the excel pivot table I included in my post; I would like to show only 31/7, 4/8,5/8 and 6/8 data. Additionally, can I get their averages to find out average sales?
Thank you very much, it solved my problem as desired.
Now, how can I get the average of values pertaining to these 4 dates only?
Can you also teach me how I shall interpret your expression? How can I make it independent from selected dates? Just replacing $ to 1? Is this a set analysis expression?
Thanks so much and have a nice day.
I think, that can be possible when we use a variable and store the current max date value. By using this variable in our expression, we can solve the probelm. Please see the attachment.
I now understood how you handled the independent dates; thanks so much
Any idea how I can get averages of these 4 records? (most recent 3 dates and also 1 week earlier)?