Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

6 Replies
Not applicable

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

Hello,

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

Thanks

Angad

MVP & Luminary
MVP & Luminary

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

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.

Not applicable

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

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

))

Not applicable

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

Hi Angad,

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

Renyta

Not applicable

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

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

))

Not applicable

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

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