Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Pivot Table - Count No. of Unique Rows for Two Dimensions

Dear Experts,

As shown below I have one DATA table. In which some SKU are common in different PLANT (e.g. SKU A).

I want to create a Pivot Table which will show the SKU which are common in two PLANT, other SKU to hide.

How to achieve the result, please guide.

Capture.JPG

 

Regards,

GT.

Labels (2)
1 Solution

Accepted Solutions
Highlighted

Re: Pivot Table - Count No. of Unique Rows for Two Dimensions

In that case, try adding DISTINCT to the condition

Sum({<SKU = {"=Count(DISTINCT PLANT) >= 2"}>} VALUE1)

 

View solution in original post

4 Replies
Highlighted

Re: Pivot Table - Count No. of Unique Rows for Two Dimensions

Use this set analysis on all the expression of the pivot table to restrict to only those SKU which are available at 2 or more plants

{<SKU = {"=Count(Plant) >= 2"}>}
Highlighted
Creator
Creator

Re: Pivot Table - Count No. of Unique Rows for Two Dimensions

Dear Sunny_Talwar,

Thanks for looking into, I have used the SET expression i.e. Sum({<SKU = {"=Count( PLANT) >= 2"}>} VALUE1)

But it is also showing SKU "B" also because SKU B is having two orders. Please guide...

Capture.JPG

 

Regards,

GT.

Highlighted

Re: Pivot Table - Count No. of Unique Rows for Two Dimensions

In that case, try adding DISTINCT to the condition

Sum({<SKU = {"=Count(DISTINCT PLANT) >= 2"}>} VALUE1)

 

View solution in original post

Highlighted
Creator
Creator

Re: Pivot Table - Count No. of Unique Rows for Two Dimensions

Thank you Sunny Talwar.... it is working exactly the way I want.

 

Thanks,

GT.