topic IF Condition to use in Pivot Table in QlikView

IF Condition to use in Pivot Table

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can anyone please help me on this.

In the Pivot Table

Dimensions: Row1,Row2 Fields

Column: Column field

Measure:

Pick(Match([RAG]),2,1,0,3),'R','A','G','W')

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

mdmukramali — Thu, 04 Jan 2018 04:59:11 GMT

Hi,

Can you share sample data file.

mdmukramali — Thu, 04 Jan 2018 06:07:30 GMT

Hi,

Instead of Adding Group in the Dimension Can you add an expression for each group.

Something like below.

Kindly find the attached Updated file.

Thanks,

Mukram.