topic Re: Create a conditioning button to hide and display column field in QlikView

Create a conditioning button to hide and display column field

prabunakil — Wed, 05 Sep 2018 09:13:47 GMT

Hi, seek everyone suggestion if i have a column field i want to hide it and only open when i click show button.

When user click show, enter password, only the column highlight yellow will be show.

This is a straight table in qliklview.

please advise.

Re: Create a conditioning button to hide and display column field

prieper — Wed, 05 Sep 2018 09:24:42 GMT

Click on a button may trigger an Inputbox to show, into which a password to be entered.

The chart then will have a conditional view to compare this variable with a stored variable.

Peter

Re: Create a conditioning button to hide and display column field

prabunakil — Wed, 05 Sep 2018 09:49:11 GMT

Yes, how ever i donno how to do it. i believe is Macro.

Re: Create a conditioning button to hide and display column field

prieper — Wed, 05 Sep 2018 10:32:14 GMT

no - not with macro, mainly

create a variable vShow with Value 0

create a variable vSystemPassword with your password

create a textfield. Under Properties - Actions - Add - External - SetVariable you set = NOT vShow

create an inputbox with vPassword and Show = vShow

create your table with conditional show: vPassword = vSystemPassword

Peter

Re: Create a conditioning button to hide and display column field

prabunakil — Wed, 05 Sep 2018 11:15:26 GMT

can u give me an example qvw file. thanks you.

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 03:09:37 GMT

Do u have example of qvw file

Re: Create a conditioning button to hide and display column field

Sergey_Shuklin — Thu, 06 Sep 2018 06:13:09 GMT

Hello, Prabu!

There are also some little hints should be done with couple of steps that Peter had mentioned.

PFA.

P.S.: The password is 12345.

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 06:20:54 GMT

Hi Sergey

initially F3 column is hide or show?

Re: Create a conditioning button to hide and display column field

Sergey_Shuklin — Thu, 06 Sep 2018 06:26:29 GMT

In instance above it's hided, but you can change conditions as you like. It doesn't make a big sense.

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 06:49:28 GMT

the file u send me is show.

Re: Create a conditioning button to hide and display column field

Sergey_Shuklin — Thu, 06 Sep 2018 06:55:50 GMT

Strange, when I'm uploadin' my example and open it I see this:

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 07:04:38 GMT

this the filke i open

Re: Create a conditioning button to hide and display column field

prieper — Thu, 06 Sep 2018 08:13:53 GMT

you may check, whether you have used the combination

Shift+Cntrl+S

This will show all hidden objects, regardless the settings/conditions in use.

Peter

edit: Shift+Cntrl+S refers to hidden objects, not columns.

Re: Create a conditioning button to hide and display column field

Sergey_Shuklin — Thu, 06 Sep 2018 08:16:07 GMT

So it's matter of the file options or some other technical conditions. If the button is working that sounds like proper result for me. There are many ways to hide the column if it visible on opening, but it's on your side.

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 08:26:20 GMT

i have tried, is not hidden. very sad. i left this part to be complete.

Re: Create a conditioning button to hide and display column field

prabunakil — Thu, 06 Sep 2018 09:23:09 GMT

i am using pivot table.