Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

stuck with the set analysis grouping and if else logic

To calculate Renew Measure consider below columns and if(Renew=1 then sum(EXP_GRS_ANN)) ) Div Bussiness Final Eff_Dt To calculate New Measure consider below columns and if(New=1 ,then sum(REN_GRS_ANN)) ) Div Bussiness Final Eff_Dt.

Please look into source and help on logic

To calculate Renew Measure consider below columns and if(Renew=1 then sum(EXP_GRS_ANN)) )

Div

Bussiness

Final

Eff_Dt

To calculate New Measure consider below columns and if(New=1 ,then sum(REN_GRS_ANN))

)

Div

Bussiness

Final

Eff_Dt

5 Replies
Highlighted
MVP
MVP

Re: stuck with the set analysis grouping and if else logic

PFA

Highlighted
Partner
Partner

Re: stuck with the set analysis grouping and if else logic

Hi,

Try:

For Renew: sum({<RENEW={1}>}EXP_GRS_ANN)

For New: sum({<NEW={1}>}REN_GRS_ANN)

Highlighted
Not applicable

Re: stuck with the set analysis grouping and if else logic

The expression you provided is in set analysis but the thing in straight table i have a number of measure are there which are using conditional logic to display the data.can you please look into how to do in if else logic to get the results

Highlighted
MVP
MVP

Re: stuck with the set analysis grouping and if else logic

Sorry, not getting your point.

Highlighted
Not applicable

Re: stuck with the set analysis grouping and if else logic

While trying with in Deatil Report the expressions are giving Null values(no result).Is it possible to use Aggr function to group by with Div,Bussiness,Final,Eff_Dt