Do not show measures if all zeros

[alexpanjhc]

Hi

i have a table that has 200 columns, most of the columns are 0s.

I was asked to create a table with customer Name/ID and all the rest of the columns added, if the columns are zero we do not want to show.

Customer Name	Customer ID	Income	Tax	Shipping Fee	Discount
John	1	50	0	0	-3
Lee	2	100	0	0	0
Lucy	3	0	0	0	0

so the Qlik sense will show only Customer Name, Customer ID,Income and Discount in the table,

[rubenmarin]

Hi Zhen, new versions of Sense (I think since June-2018 version) allows to set conditional expressions, in example, the condicional expression for Tax can be "Sum(Tax)<>0" or more adjusted: "Count({<Tax={"<>0"}>} Tax)>0"

[alexpanjhc]

Thanks Ruben,

Is there an easy solution for the November 2017 version?

[rubenmarin]

Not that I know, some extensions allows fro customized reports where users select measures and dimensiones, but not dinamically show/hide columns based on it's values

[dplr-rn]

Has it been implemented? can you share a screenshot? i have sept 2018 release and cant find it

[Lisa_P]

Screenshot from Cloud version .....

[dplr-rn]

thanks. it available only for straight and pivot tables? or any other visualizations?

[rubenmarin]

Hi Dilip, only for tables that I know... I have tested bar chart and some other objects and the option doesn0t exists. just pivot and straight tables.

[dplr-rn]

a start i guess 🙂