Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sebastiandperei
Valued Contributor

Re: How to link input box with predefined values to an expression in a pivot table?

When do you created the trigger? I haven't found it.

So, you changed the expression for make it at the begin. Now, we have a field that makes the filter function.

The variable will only "trigger" the selection on the field Show...

I've modified all these concepts, and attached the document again.

Not applicable

Re: How to link input box with predefined values to an expression in a pivot table?

Sorry, I attached the wrong file. 

This is great, thank you so much for your assistance!!!!!!!!!!!!!!!!

Highlighted
Not applicable

Re: How to link input box with predefined values to an expression in a pivot table?

Sebastian,

Can you take a quick look at my file and tell me what I am doing wrong with my input box?  I created a new file based on a different grouping.  However, my input box is not working?  I added my trigger and created the variable but the data is not linked to the table????

sebastiandperei
Valued Contributor

Re: How to link input box with predefined values to an expression in a pivot table?

The data is linked, you see that where you select a value in PercentageExpended, the table shows you only their values.

I think that the problem is the name of the field, with this char (I can't find it in my keyboard!)

So, you must put the triggers in Change value (look at the last app I've sent)

Not applicable

Re: How to link input box with predefined values to an expression in a pivot table?

I did try that and I was still not able to link to the file. 

But, I finally did after I made the "Variable1" all lower case in the trigger.  Who would have known, but thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!