Pivot Table: Show Column if columnno()

[katierusso]

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

[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

[katierusso]

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)