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

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

Thu, 18 Jun 2015 11:24:09 GMT

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.

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

swuehl — Thu, 18 Jun 2015 11:37:13 GMT

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

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

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

Thu, 18 Jun 2015 11:43:49 GMT

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

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

gautik92 — Thu, 18 Jun 2015 11:48:06 GMT

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

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

swuehl — Thu, 18 Jun 2015 11:49:03 GMT

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

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

qlikmsg4u — Thu, 18 Jun 2015 11:56:33 GMT

Like this?

Load * Inline [

Date

02/12/2015

09/24/2015];

In front end

Let vStart = Max(Date);

Let vStartPlus1 = AddMonths(vStart,1);

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

Thu, 18 Jun 2015 12:11:15 GMT

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

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

qlikmsg4u — Thu, 18 Jun 2015 12:15:34 GMT

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