How to hide column in Qliksense June 2018

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In June 2018 version I have found one option like Show Column if.

In the below table by using this option how to hide the Unique Visitors Measure Column.

Please help me on this.

Please find the below attached app.

Thanks in advance.

[arulsettu]

you can use condition to hide and show. for example i used if date selected to display the new visitor column

[OmarBenSalem]

It's just like the condition under the adds-on;

show column if :

ur expression

example, u want to showthe column new visitors only if u select a year

so the condition to show this column would be for example:

count(distinct Year)=1

[MayilVahanan · Accepted solution]

Hi

This option is used to "display the column when the condition is satisfied which entered in the box".

For: If the "Unique Visitor" column need to display when the user select a Month. then enter the condition like below

GetselectedCount(Month) = 1

Hope it helps to understand.

[OmarBenSalem]

Do u hate me?

[mahitham]

No Bro 

I Just tried your option also. Its also working.

Thanks for your help. Marked as Helpful. Already I have used Correct Answer.

Community has to Provide Correct Answer option for more replies

[gerald_lebret]

Hi,

This option works perfectly with a table.

However, when using a pivot table, if I have  a dimension on top of the values, it won't work.

Let me explain with an example:

                                              Year 1                                                                 Year 2                                   Difference

                          Qty         Unit Price           Amount         Qty        Unit Price     Amount                 Qty             Amount

Item 1

Item 2

I want the qty difference column and/or the amount difference column to appear only if they're different from 0.

But, from the moment, qty is not equal 0 in year one or year 2, QS shows the difference qty even if it equals 0.

Can anyone help?

Thanks

[mbjallow6]

I am working on an app not exactly the as the screenshot. using the screenshot as an example, i want to create a condition that some user can all the three columns(RED,BLUE,GREEN) whereas other user can see only 2 columns or so. Do you have any idea of how to do this?

Thank you in advance.

[gerald_lebret]

Hello,

Have you thought of section access?

It could work depending on how your data are structured

[mbjallow6]

Yes i have spend hours and hours reading about section access. However, when i applied it in the manner i understood it, it didn't worked i aspected.

 above is my data load script.