Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a KPI with just a date measure and I wish to show the current selected date + 1 month. So for example I would have 22.05.2015 and I want the KPI to show 22.06.2015. How can I accomplish this?
I am using Qlik Sense if that helps.
Thank you.
Maybe something like this (would be easier if you could post your current KPI expression):
=Sum({<DateField = {'$(=Date(addmonth(max(DateField),1)))'} >} Value)
Hi swuehl,
I just want to show the date on KPI, not another value. I created a measure called vMaxDatePlusMonth as
Let vMaxDatePlusMonth = Max(addmonths("$(StartDate)",1))
if you want it dynamic create a variable and set as 1 in expression jus add the variable
Not sure if I understand.
Do you want to calculate the variable depending on current user selections? Based on which date field?
Your above variable will be set once in the script, so it will not be changed by user selections.
You may define the variable using SET like:
SET vMaxDatePlusMonth = '=Date(addmonth(max(DateField),1))';
Like this?
Load * Inline [
Date
02/12/2015
09/24/2015];
In front end
Let vStart = Max(Date);
Let vStartPlus1 = AddMonths(vStart,1);
Hi, yes I had something like that earlier but the date is not appearing in KPI. It shows a dash '-' across the screen. I'm not sure what's wrong...
Please attach your sample app so that we can able to help you