Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Create a conditioning button to hide and display column field

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

Capture.JPG

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

This is a straight table in qliklview.

please advise.

15 Replies
Highlighted
Master II
Master II

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Master II
Master II

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

Do u have example of qvw file

Highlighted
Specialist
Specialist

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.

Highlighted
Contributor III
Contributor III

Hi Sergey

initially F3 column is hide or show?

Highlighted
Specialist
Specialist

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

Highlighted
Contributor III
Contributor III

the file u send me is show.