Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

farheenayesha
Contributor

How to hide columns with Null values in Qliksense

Hi,

     I need help in hiding the columns with values as Null or NA.

Example:

     In the below data(Pic 1) i wan to hide the cells with values as NA. Basically i want to show the rep names for different rep types in one single row as shown in second pic(Pic 2). Please let me know if more clarification is required.

Pic 1:

Capture.JPG

I need result as below

Pic 2:

Pic 2.JPG

Message was edited by: Ayeesha Farheen

1 Solution

Accepted Solutions

Re: How to hide columns with Null values in Qliksense

Check the attached

14 Replies

Re: How to hide columns with Null values in Qliksense

It seems that you are using Rep Type 1, 2, 3, 4, 5 as dimensions in your chart, but instead you might want to use it as expression... might have to share some data to see how it looks to give you the exact expression. Some modification might be needed for Sales and PY Sales expression also...

farheenayesha
Contributor

Re: How to hide columns with Null values in Qliksense

Hi Sunny,

     Thanks for the quick response. Please find new working file attached. I have changed the numbers from above example. Kindly help me to get the solution.

Thanks,

Ayeesha

Re: How to hide columns with Null values in Qliksense

Check the attached

farheenayesha
Contributor

Re: How to hide columns with Null values in Qliksense

Hi Sunny,

     You are really great. Got so quick solution for my problem. Thank you so much !!!!!!!!!!!!

one quick question. Is it possible to get the below view in the same table (above example). I want to show products as columns and their Sales and PY Sales below each product. Please let me know is it feasible.

Capture.JPG

Re: How to hide columns with Null values in Qliksense

It might be possible but what all dimensions do you need?

farheenayesha
Contributor

Re: How to hide columns with Null values in Qliksense

Same dimensions as in the above table (Acct no,Acc name, Division). Just need products as columns and their Sales and PY Sales below each product.

Re: How to hide columns with Null values in Qliksense

How about the Rep Type? They are needed as dimension also?

farheenayesha
Contributor

Re: How to hide columns with Null values in Qliksense

Yes..

Re: How to hide columns with Null values in Qliksense

Check the attached

Capture.PNG

Community Browser