Excluding particular filter in set analysis

Mon, 09 Oct 2017 12:48:40 GMT

Hi Team,

I Have a senario like i have a filter in qlikview which is not based on particular field instead of that i am using if statement(If(Condition,Y,N).

If i choose Y or N accordingly data will populate.

The question is i have pivot table(8 columns- each column has different set analysis calculation) with set analysis when i choose Y or N it's effecting the some of columns(consider any column-6 or 8).

It should not effect those required columns. Normally in set analysis we will do like fieldname=, then it won't effect based on those selection that particular field.

It have tried to create variable for if statement and placed in set analysis it's not working.

Can you suggest me the solution because it's urgent. I am trying in different ways.

Re: Excluding particular filter in set analysis

vishsaggi — Mon, 09 Oct 2017 16:50:30 GMT

Can you share your expression you are using and where you have the problem and what is not working? A sample data file should help if possible upload here.

topic Excluding particular filter in set analysis in QlikView

Excluding particular filter in set analysis

Re: Excluding particular filter in set analysis