Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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"
Thanks Ruben,
Is there an easy solution for the November 2017 version?
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
Has it been implemented? can you share a screenshot? i have sept 2018 release and cant find it
Screenshot from Cloud version .....
thanks. it available only for straight and pivot tables? or any other visualizations?
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.
a start i guess 🙂