topic if function for dummy dimension (with set analysis) not work in QlikView

if function for dummy dimension (with set analysis) not work

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have a question about if function in qlikview. I'm newbie with qlikview, and now i have a problem when i have a pivot chart with dummy dimension where i must get the value of that dummy dimension for every 3 months.

I get the value with the set analysis, but when i have month for selection, this chart is not get the value of 3 months, just get the value of month that i selected. I want this chart still get the value of 3 months however I selected just 1 month.

Please help me to find out what's wrong with my chart.

Thank you so much.

Regards,

Renyta

Message was edited by: Renyta Irene this is the new attachment..thanks

Re: if function for dummy dimension (with set analysis) not work

Mon, 25 Nov 2013 07:32:29 GMT

Hello,

Your attachment is not loading. The load is failing. Can you please re-attach it or post the expressions here.

Thanks

Angad

Re: if function for dummy dimension (with set analysis) not work

jagan — Mon, 25 Nov 2013 07:33:56 GMT

Hi,

Attached file is corrupted I think, I am not able to open. If you want to ignore selections of the Month Dimension just do like this

=Sum({<MonthDimensionName=>} MeasureName)

Regards,

Jagan.

Re: if function for dummy dimension (with set analysis) not work

Mon, 25 Nov 2013 07:48:21 GMT

this is actually my expression for my pivot chart:

if(ValueList('a','b')='a',

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}sum_contract_no),

if(ValueList('a','b')='b',

(sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_REPOSES)/

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_INSTALLMENT))

))

Re: if function for dummy dimension (with set analysis) not work

Mon, 25 Nov 2013 08:06:26 GMT

Hi Angad,

Thanks for your reply, i do re-attach on my post earlier. please to see it. thanks

Renyta

Re: if function for dummy dimension (with set analysis) not work

Tue, 26 Nov 2013 04:16:27 GMT

Hi Angad, this is actually my expresion in my pivot chart:

if(ValueList('a','b')='a',

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}sum_contract_no),

if(ValueList('a','b')='b',

(sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_REPOSES)/

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_INSTALLMENT))

))

Re: if function for dummy dimension (with set analysis) not work

Tue, 26 Nov 2013 04:19:27 GMT

Hi Jagan,

Actually i get that set analysis on my expression, my expression actually is like this one:

if(ValueList('a','b')='a',

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}sum_contract_no),

if(ValueList('a','b')='b',

(sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_REPOSES)/

sum({$<TRANSDAT={">=$(=AddMonths( max(TRANSDAT),-2 )) <=$(=AddMonths( max(TRANSDAT),0 ))"},MONTH=,YEAR=>}SUM_INSTALLMENT))

))

can you please to see it and tell me where i'm wrong in my expression?

Thanks,

Renyta