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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
katierusso
Contributor II
Contributor II

Pivot Table: Show Column if columnno()

I am trying to use the columnno() function in the Show column if condition for my conversion rate measure within my pivot table.  I am trying to show the quote counts for converted and unconverted quotes, and then show the conversion rate only for the totals column. The columnno() function is working properly. Why do I get "The calculation condition is not fulfilled"?

June 2019 Qlik Sense Desktop 13.32.2

 

Labels (1)
3 Replies
Taoufiq_Zarra

I don't exactly understand what you expect, but to correct the error :

the function ColumnNo()   starts with 1 : The first column is number 1.

while in the test you're looking for the value 0

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
katierusso
Contributor II
Contributor II
Author

In the pic attached, you can actually see that the Columnno() returns zero in a pivot table for Totals column. When using this calculation for the Show column if condition, I expected the pivot table to show three columns for #Quotes: Total, 0 , 1 (0 and 1 are converted indicators), then for Conversion rate, I only wanted to show one column: Total (not showing 0 and 1 column).

Taoufiq_Zarra

I'll wait a little bit, but I'm not sure that's possible on a pivot table.

However, you can do it on a simple table.

But in the pic attached Columnno() return 1 and 2 🙂 (0 and 1 is for Converted field)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉