Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Deepali_Prabhu
Contributor
Contributor
‎2023-05-24 07:43 AM

To display one column in Pivot table with 2 entries

In a pivot table, the column added before the values(Sale) has two entries : 'Yes' and ' No' as below:

But I need to display just the Yeses. Any suggestions are welcome.

2021 2022 2023
Sale Sale % Sale Sale % Sale Sale %
Yes No Yes No Yes No Yes No Yes No Yes No
Labels (2)
Labels
635 Views
0 Likes
2 Replies
vinieme12
Champion III
Champion III
‎2023-05-24 11:00 PM

use a Calculated Dimension

 

aggr(  only ({<Field = {'Yes'}>} Field ) , Field )

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
602 Views
0 Likes
Deepali_Prabhu
Contributor
Contributor
‎2023-06-15 05:17 AM
Author

Should this formula be put into "Show column if" segment of the field ?

 

546 Views
0 Likes