How to have KPI show current selection date + 1 month?

[#1]

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.

[swuehl]

Maybe something like this (would be easier if you could post your current KPI expression):

=Sum({<DateField = {'$(=Date(addmonth(max(DateField),1)))'} >} Value)

[#3]

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))

[gautik92]

if you want it dynamic create a variable and set as 1 in expression jus add the variable

[swuehl]

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))';

[qlikmsg4u]

Like this?

Load * Inline [

Date

02/12/2015

09/24/2015];

In front end

Let vStart = Max(Date);

Let vStartPlus1 = AddMonths(vStart,1);

[#7]

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...

[qlikmsg4u]

Please attach your sample app so that we can able to help you