topic Re: if to set analysis in QlikView

if to set analysis

Wed, 20 Jan 2016 13:28:27 GMT

i need some help whit this IF.

I nedd change it to set analysis

'=Sum(IF((SEG='A' and DATE_REN<AddMonths(vFec-1, -1)),1,IF(SEG='ADMINISTRACIONES',0,IF(DATE_REN < vFec-1,1,0)))*IF(SALES>0,SALES,0))

Re: if to set analysis

ajsjoshua — Wed, 20 Jan 2016 13:31:38 GMT

pls put some sample.

Re: if to set analysis

Wed, 20 Jan 2016 14:27:21 GMT

I believe its not possible to completely turned the expression into Set Analysis. But if you can add the new field on Sales with some filters in the script level, may we can write set analysis on UI.

Can you please post sample qvw ?

Re: if to set analysis

miguelbraga — Wed, 20 Jan 2016 15:06:30 GMT

To turn this expression in set analysis you need to add some flag fields with your if functions like this:

Flags_ETL:

LOAD

IF(SALES>0,SALES,0)) as PositiveSales,

IF(SEG='A', 1, 0) as FlagSeg,

IF(DATE_REN<AddMonths(vFec-1, -1), 1, IF(DATE_REN < vFec-1, 1, 0)) as FlagDate,

Resident YourMainTable;

Then you can use a expression like this:

=sum({$<FlagSeg = {1}, FlagDate = {1}>} PositiveSales)

Regards,

Re: if to set analysis

Wed, 20 Jan 2016 15:11:39 GMT

May be vFec varibale is generated by user selections ?