This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi I have a filter Date_Worked. I have a KPI object that shows the sum of the HOURS_WORKED for the selected date. (That are reportable=y and excluded =n)
For the secondary KPI value I would like the Previous day from the selected filter. in the formula expression .
Current KPI with the Max Date Worked Selected- This works okay in the formual expression field
To get the previous day I have tried many iterations of -1. Creating date_worked a s a variable, trying to match the format.
Still I do not get any correct results just 0 appears.
Please can someone helped me ? I have also tried ....
Still no results....
You have to make sure that your date is seen as a date first. Below is an example:
LOAD Date#(Date_Worked,'DD-MMM-YY') AS Date_Worked,
Your formula for the max date selected will be:
The expression for the day before the max date selected will be:
Just replace the part in red with your date's format (which can be seen by putting Date_Worked into a filter pane).
Hope this helps.
View solution in original post
Awesome, Thanks very much.