topic Pivot Table: Show Column if columnno() in App Development

Pivot Table: Show Column if columnno()

katierusso — Sat, 16 Nov 2024 19:23:16 GMT

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

Re: Pivot Table: Show Column if columnno()

Taoufiq_Zarra — Thu, 26 Dec 2019 14:25:46 GMT

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

Re: Pivot Table: Show Column if columnno()

katierusso — Thu, 26 Dec 2019 14:54:06 GMT

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).

Re: Pivot Table: Show Column if columnno()

Taoufiq_Zarra — Thu, 26 Dec 2019 15:11:53 GMT

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)