topic Re: if Condition in set analysis in QlikView

if Condition in set analysis

abhaysingh — Thu, 20 Aug 2015 05:38:49 GMT

HI Guys,

HOw can I put below expression in Set Analysis?

=if([Category Name]='Beer',sum(Quantity)/24,sum(Quantity)/12)

thanks

Abhay

gautik92 — Thu, 20 Aug 2015 05:48:15 GMT

Sum({<[Category Name]='Beer'>}Quantity)/24,Sum({<[Category Name]='Beer'>}Quantity)/12

sunny_talwar — Thu, 20 Aug 2015 05:49:40 GMT

I don't think this can be converted into a set analysis expression. Best you can do is this:

=Sum(Quantity)/If([Category Name] = 'Beer', 24, 12)

sunny_talwar — Thu, 20 Aug 2015 05:53:11 GMT

Alternatively you can create a flag in a script:

Table

LOAD [Category Name],

Quantity,

OtherField

FROM Source

FlagTable:

LOAD Distinct [Category Name],

If([Category Name] = 'Beer', 24, 12) as Flag

Resident Table;

Expression:

Sum(Quantity)/Flag

CELAMBARASAN — Thu, 20 Aug 2015 05:55:37 GMT

Try the Below one

RangeSum(sum({<[Category Name]='Beer'>}Quantity)/24,sum({<[Category Name]-='Beer'>}Quantity)/12)

Hope this helps

sunny_talwar — Thu, 20 Aug 2015 05:57:26 GMT

Beautiful... This is very creative

mohammadkhatimi — Thu, 20 Aug 2015 06:05:44 GMT

Hie...

=sum({<[Category Name]={'Beer'}>}Quantity)/24+sum([Category Name]={'*'}-{'Beer'}Quantity)/12)

Hope this will helps you..!!

Regards,

Mohammad