Discussion board where members can get started with QlikView.
I have a data like below
My req is: I need to get the data when I filter 3build I need only greater than 3days durion Renum should display
and for 5Build I need to display more than 7Days Renum should display
by default it should display all the data.
below is expression which I used but it is not working.
=if([ Name]='3Build' and [ Duration]>=3,[ReNum])
if([Name]='5Build' and [Duration]>7,[ReNum],[ReNum]))
what is wrong in my exp?
Check this expression:
[Name2]='3Build' and [Duration2]>=3,
[Name2]='5Build' and [Duration2]>7,
[Name2]<>'5Build' and [Name2]<>'3Build',
And I while make QS file
Miguel del Valle
Mymistake, in a expression instead of Renum we need use Duration.
And Q? Do you have separate filter for 3Build and 5Build selection? If no, then it will reduce your data based on selection and then it will give you result.