Set analysis inside if statement

Thu, 29 Aug 2013 13:57:54 GMT

Does anyone know how to fix this problem? I cant seem to get the expression to work inside a if statement in a straight table with a dimension called label_churnSummary, but i place it in a textbox, it works fine.

Am i missing something? Thanks in advance.

if(label_churnSummary='Retention %',

num(

if(len(GetFieldSelections([FIN YEAR]))>1 or len(GetFieldSelections(MONTH_NAME))>1,

(

num(sum({<[FIN YEAR]=,MONTH_NAME=,label_churnSummary=,Measure_churnSummary={'Corrected'},MonthYear={'$(=MonthName(AddMonths(max(Date),-11)))'}>}value_churnSummary),'###0')

)

sum({<[FIN YEAR]=,MONTH_NAME=,label_churnSummary=,Measure_churnSummary={'Corrected'},MonthYear={'$(=(MonthName(addmonths(today(),-11))))'}>}value_churnSummary)

)

,'###0')

num(

if(len(GetFieldSelections([FIN YEAR]))>1 or len(GetFieldSelections(MONTH_NAME))>1,

sum({<[FIN YEAR]=,MONTH_NAME=,MonthYear={'$(=MonthName(AddMonths(max(Date),-11)))'}>}value_churnSummary),

sum({<[FIN YEAR]=,MONTH_NAME=,MonthYear={'$(=(MonthName(addmonths(today(),-11))))'}>}value_churnSummary)

)

,format_Churn)

Re: Set analysis inside if statement

michael_maeuser — Thu, 29 Aug 2013 14:10:47 GMT

do you have a sample qvw?

its hard to guess whats going on without seeing anything.

topic Set analysis inside if statement in QlikView

Set analysis inside if statement

Re: Set analysis inside if statement