Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Covert IF Condition into set analysis

Hi Folks,

I have a problem converting if condition into set analysis

i have variable expression, I need to simplify in set analysis. Can anyone help this .

If(IF(Payment = 'NET' AND Payment_Discount<>0 ,1,0)=1,

-(TCNET * NumberOFTrans ) + (Annual_Trans * (PaymentDiscount_PerDays+AvgNET) /365) * FundRating

+ Annual_Trans * Payment_Discount )

Kindly help to convert the above expression in set analysis.

I tried but still there is expression error.

Thanks in advance

Vignesh kumar

3 Replies

Re: Covert IF Condition into set analysis

Try this:

sum({<{Payment={'NET'},Payment_Discount={'<>0'}>} -(TCNET * NumberOFTrans ) + (Annual_Trans * (PaymentDiscount_PerDays+AvgNET) /365) * FundRating + Annual_Trans * Payment_Discount))


talk is cheap, supply exceeds demand
Not applicable

Re: Covert IF Condition into set analysis

Hi Gysbert, Thanks for your help, but still am getting expression error. And too i have to check where the set analysis is equal to 1.

Kindly help me with this issue... Not only in set analysis if there is any other way apart from if condition. That would be gretful.

Regards,

Vignesh kumar

Re: Covert IF Condition into set analysis

Please post a small qlikview document that explains what you want.


talk is cheap, supply exceeds demand
Community Browser