Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mahitham
Contributor

How to hide column in Qliksense June 2018

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.

hide column.png

1 Solution

Accepted Solutions

Re: How to hide column in Qliksense June 2018

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.

View solution in original post

10 Replies
arulsettu
Honored Contributor III

Re: How to hide column in Qliksense June 2018

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

Partner
Partner

Re: How to hide column in Qliksense June 2018

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

Re: How to hide column in Qliksense June 2018

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.

View solution in original post

Partner
Partner

Re: How to hide column in Qliksense June 2018

Do u hate me?

mahitham
Contributor

Re: How to hide column in Qliksense June 2018

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

Partner
Partner

Re: How to hide column in Qliksense June 2018

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

Highlighted
mbjallow6
New Contributor II

Re: How to hide column in Qliksense June 2018

Screenshot (204).png

 

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.

Partner
Partner

Re: How to hide column in Qliksense June 2018

Hello,

Have you thought of section access?

It could work depending on how your data are structured

mbjallow6
New Contributor II

Re: How to hide column in Qliksense June 2018

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.Screenshot (233).png

 above is my data load script.