Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.