topic Re: Pivot Expression in QlikView

Pivot Expression

upaliwije — Sun, 08 Jun 2014 15:27:45 GMT

In my pivot Table the following expression is working fine

=SUM({<I_MONTH = {"$(=Only(I_MONTH))"},I_DAY = {">25"}>} [PREMIUM])

But the expression given below returns 0 value

=SUM({<I_MONTH ={"$(=Only([1_MONTH])-1)"},I_DAY = {">25"}>} [PREMIUM])

Can some pls tell me what is wrong with 2nd expression

Sun, 08 Jun 2014 15:48:07 GMT

maybe this difference is a problem:

Only(I_MONTH

Only([1_MONTH])-

Sun, 08 Jun 2014 18:34:54 GMT

Use the below expression as 2nd expression and see if this works, I have added () to Only(1_MONTH)

=SUM({<I_MONTH ={"$(=(Only([1_MONTH]))-1)"},I_DAY = {">25"}>} [PREMIUM])

Mon, 09 Jun 2014 06:57:07 GMT

Can you try below:

=SUM({<I_MONTH ={"$(=$(=Only([1_MONTH]))-1)"},I_DAY = {">25"}>} [PREMIUM])

Thanks,

Angad

tresB — Mon, 09 Jun 2014 07:00:46 GMT

Two possibilities:

typo - [1_MONTH] or [I_Month]
If your [1_Month] field is not numeric 'only([I_MONTH])-1' would not work for obvious reason.

jagan — Mon, 09 Jun 2014 07:01:26 GMT

Hi,

What is your I_MONTH values format? Is it 1,2,3,4,etc. If it is numeric then try below expression

=SUM({<I_MONTH ={"$(=Only([I_MONTH])-1)"},I_DAY = {">25"}>} [PREMIUM])

Also you are using 1_MONTH (numeric month) please check.

Regards,

Jagan.