How to hide columns with Null values in Qliksense

[farheenayesha]

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:

I need result as below

Pic 2:

Message was edited by: Ayeesha Farheen

[farheenayesha]

You are really genius.I really have no words. Thank you so much!!!!!!!!!!

Just last question. is it possible to use Sales and PY Sales coulmns along with the products. Please find the snapshot below

[sunny_talwar]

Not sure I understand this screenshot?

[farheenayesha]

No Problem Sunny. Thank you so much for all your help. I am trying to achieve the same thing in Qliksense but unfortunately not able to use many columns, as there is no scroll bar in Qliksense tables.

[farheenayesha]

Hi Sunny,

     Is there any way to show total sales instead of the sales of reptypes for the account. I want the sales of 'NA' also in the total sales?

[sunny_talwar]

Can you share an Excel file with the output you expect to see?