Discussion board where members can get started with Qlik Sense.
I wan to change KPI object value based on period... for example I select Jun month period.. then I should be able to get May month revenue or I select May month I should be able to see April month. I would appreciate to provide any support
Do you have a Date field?
No I don't have date field...
Please do the following steps:
1. calculate month and year according to a field.
a. using Purgechar function your date should calculate.
2. Calculate month Year.
Date(Date#(PurgeChar('XTD - Jun-17','XTD - '),'MMMYY'),'DD-MMM-YYYY')
2. Write set analysis as Below .
That is not working ...I added your date expression but it is displaying 01-Jun-2017.but when I checked normal functioning stopped working