Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sskiggs1
New Contributor III

Variables behind a button

Hoping someone can help.

In the attached example, how do i get it that when the past date button is selected that the table on the right reflects to just show those that fall within the criteria of the variables behind the text boxes.

Thanks.

Tags (2)
1 Solution

Accepted Solutions

Re: Variables behind a button

Please find attached

Capture.PNG

16 Replies

Re: Variables behind a button

1) The chart on the right is a table box, you want to do this in table box or straight table is also okay?

2) So, when I select Past Date, I see a total count of 4 across the 6 text boxes.. is the expectation to see only 4 rows which meet the criteria?

YoussefBelloum
Esteemed Contributor

Re: Variables behind a button

Hi,

You're using a TableBox, it's parameters are limited. could you use a simple table instead? if so, then you could use different expressions that look like your variable expressions (with a conditional display)

Highlighted
sskiggs1
New Contributor III

Re: Variables behind a button

Either Table box or straight table would be useful.

Yes, I would expect to only see those four lines as the output

Re: Variables behind a button

Please find attached

Capture.PNG

sskiggs1
New Contributor III

Re: Variables behind a button

This is what I am looking for! Thank you.

How would this work is a chart already has another expression though? I have a chart with Owner name, then a count expression, but the expression is just outputting the same on every row?

button.PNG

Re: Variables behind a button

That is because you have stored your variable with an '=' sign. Remove the '=' sign from your variables

sskiggs1
New Contributor III

Re: Variables behind a button

Thank you so much!

Re: Variables behind a button

No problem at all... please close the thread by marking correct and helpful response if you got what you wanted.

Best,

Sunny

sskiggs1
New Contributor III

Re: Variables behind a button

I have noticed that the expression is not working as I would like. I believe it is because of the range sum. It is adding all of the records.

e.g. Jef with an urgency of Medium &risk Factor High should be 8 but it is 22.

I tried a RangeCount instead but this also did not work.