Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
New to Qlik Sense and I am building my first application. I am building a Pivot Chart in order to look at 3 metrics over the last 8 days for several hundred values (as dimension).
I added the Date Picker object and I am trying to set a default start and end date. For the end date I just select the Max(FieldNameDate), but for the start date, how do I select the Max(FieldNameDate) but subtract 8 days from that?
I saw some post here about using expressions, however, I don't fully understand what the expressions are doing.
Can anyone point me in the right direction?
Thank you all.
Thank you all for your input. I was able to figure out the way to do this with you dataset with the help of another local QlikSense dev.
Basically I was able to import all my data, but limit the dataset for a pivot table to just the last 8 days but using the code below for all my measures.
Only({<[dateField] = {">$(=Date(Today() - 8))"}>}[measure])
check this video
Thank you for your response. However, I could not get this to work.
Just realized you are using date picker (guessing from the bundle). Dont believe there is a way to do that with that.
i know it is possible in some paid extensions e.g. climber selections bar
Please go thru the below link and see if that helps:
https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-create-Date-Picker-in-Qlik-Sense/td-p/1172549
Thank you all for your input. I was able to figure out the way to do this with you dataset with the help of another local QlikSense dev.
Basically I was able to import all my data, but limit the dataset for a pivot table to just the last 8 days but using the code below for all my measures.
Only({<[dateField] = {">$(=Date(Today() - 8))"}>}[measure])