topic Re: Pivot Label Calculation Problem in QlikView

Pivot Label Calculation Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I've created one variable like

vCurrMonth = Max(Month(Today())-2)

And i've create object. I want to show Label like Actual(Jul) --

In future, we change the variable like =Max(Month(Today())-1) -- I want label like Actual(Aug) -- Like that

I've attempt this

='Actual' & chr(32) & '(' & Date#(Max(Month(Today())-2),'MMM') & ')'

It is giving Actual(7) -- I want Actual (Jul)

Can anyone assist me?

settu_periasamy — Mon, 05 Sep 2016 17:57:18 GMT

Have you tried this?

='Actual' & chr(32) & '(' & Date(Date#(Max(Month(Today())-2),'MMM'),'MMM') & ')'

='Actual' & chr(32) & '(' & Date(Max(Month(Today())-2),'MMM') & ')'

vishsaggi — Mon, 05 Sep 2016 17:59:25 GMT

Did you try this:

vCurrentMonth = Max(MonthName(Today())-2)

='Actual' & chr(32) & '(' & Month(Max(MonthName(Today())-2)) & ')'

Anil_Babu_Samineni — Mon, 05 Sep 2016 18:10:28 GMT

Settu,

I've done these while i have the calculated variable,

But what i did is - I've created one static variable like vCurrMonth = 7

Expression is this.

='Actual' & chr(32) & '(' & $(vCurrentMonth) & ')'

Label showing like Actual (7) - I want to show 7 instead of Jul. Does it possible?

settu_periasamy — Mon, 05 Sep 2016 18:20:15 GMT

Ok. then try like this..

='Actual' & chr(32) & '(' & Date(Date#($(vCurrentMonth),'M'),'MMM') & ')'

Anil_Babu_Samineni — Mon, 05 Sep 2016 18:25:27 GMT

Rocking