Discussion board where members can get started with QlikView.
Can anyone please help me on this.
In the Pivot Table
Dimensions: Row1,Row2 Fields
Column: Column field
Now the requirement is I have to derive one Status Column with the below logic
Under Column Field have the records like Electronics,Fruits,Clothes,Books,Remotes,Robos,Products.
If all these records are W then the the status should be W
If any of the record contains Red then the Status should be R.
Please provide the solution to get the status column with the above condition.
Thanks in advance
Instead of Adding Group in the Dimension Can you add an expression for each group.
Something like below.
Kindly find the attached Updated file.
View solution in original post
Can you share sample data file.