Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Do not show measures if all zeros

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 NameCustomer IDIncomeTaxShipping FeeDiscount
John15000-3
Lee2100000
Lucy30000

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

8 Replies
Highlighted

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"

Highlighted
Specialist
Specialist

Thanks Ruben,

Is there an easy solution for the November 2017 version?

Highlighted

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

Highlighted
Partner
Partner

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

Highlighted
Employee
Employee

Screenshot from Cloud version .....

Thread 313750.PNG

Highlighted
Partner
Partner

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

Highlighted

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.

Highlighted
Partner
Partner

a start i guess 🙂