Create a conditioning button to hide and display column field

[prabunakil]

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.

[prieper]

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

[prabunakil]

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

[prieper]

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

[prabunakil]

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

[prabunakil]

Do u have example of qvw file

[Sergey_Shuklin]

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.

[prabunakil]

Hi Sergey

initially F3 column is hide or show?

[Sergey_Shuklin]

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

[prabunakil]

the file u send me is show.