Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Your attachment is not loading. The load is failing. Can you please re-attach it or post the expressions here.
Thanks
Angad
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.
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))
))
Hi Angad,
Thanks for your reply, i do re-attach on my post earlier. please to see it. thanks
Renyta
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))
))
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