topic Re: Variables behind a button in QlikView

Variables behind a button

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Variables behind a button

sunny_talwar — Mon, 25 Jun 2018 12:00:13 GMT

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?

Re: Variables behind a button

YoussefBelloum — Mon, 25 Jun 2018 12:01:41 GMT

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)

Re: Variables behind a button

Anonymous — Mon, 25 Jun 2018 12:40:39 GMT

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

sunny_talwar — Mon, 25 Jun 2018 12:48:48 GMT

Please find attached

Re: Variables behind a button

Anonymous — Mon, 25 Jun 2018 13:27:35 GMT

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?

Re: Variables behind a button

sunny_talwar — Mon, 25 Jun 2018 13:31:49 GMT

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

Re: Variables behind a button

Anonymous — Mon, 25 Jun 2018 15:01:56 GMT

Thank you so much!

Re: Variables behind a button

sunny_talwar — Mon, 25 Jun 2018 15:04:36 GMT

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

Best,

Sunny

Re: Variables behind a button

Anonymous — Thu, 28 Jun 2018 09:34:20 GMT

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.

Re: Variables behind a button

sunny_talwar — Thu, 28 Jun 2018 10:46:58 GMT

I don't think I follow you completely here... Let's take your example and look at the image below

I selected Jeff... and for Medium Urgency and High Risk Factor... I see 3, how are you getting 8?

Also, if you see in the table... I see 3 rows... where do you see 22 rows?

What am I missing?

Re: Variables behind a button

Anonymous — Thu, 28 Jun 2018 11:20:37 GMT

if you select through the drill down chart that was also attached the numbers are incorrect.

*Apologies, I mean't Medium and Critical

Re: Variables behind a button

sunny_talwar — Thu, 28 Jun 2018 11:32:27 GMT

There are multiple issues

1) You are using set analysis in your variable to show specific value regardless of selection in Urgency and Risk Factor... to fix this... you can try this

Sum(Aggr(If(vShow = 0,

RangeSum($(vCriticalHighPD), $(vHighHighPD), $(vCriticalMediumPD), $(vHighMediumPD), $(vCriticalLowPD), $(vHighLowPD)),

If(vShow = 1,

RangeSum($(vCriticalHigh), $(vHighHigh), $(vCriticalMedium), $(vHighMedium), $(vCriticalLow), $(vHighLow)),

RangeSum($(vHighHighN14), $(vCriticalMediumN14), $(vHighMediumN14), $(vCriticalLowN14), $(vHighLowN14)))), Age, [Last Observed], [Risk Factor], Urgency))

2) One of your variable vCriticalHigh was incorrectly specified

So, basically Urgency Medium was getting double counted....

Re: Variables behind a button

Anonymous — Thu, 28 Jun 2018 11:42:41 GMT

Fixed the wrongly specified variable (thank you!)

However, the if statement now does not show half of my owners in the chart....?

Re: Variables behind a button

sunny_talwar — Thu, 28 Jun 2018 11:45:36 GMT

See if this helps

Sum(Aggr(If(vShow = 0,

RangeSum($(vCriticalHighPD), $(vHighHighPD), $(vCriticalMediumPD), $(vHighMediumPD), $(vCriticalLowPD), $(vHighLowPD)),

If(vShow = 1,

RangeSum($(vCriticalHigh), $(vHighHigh), $(vCriticalMedium), $(vHighMedium), $(vCriticalLow), $(vHighLow)),

RangeSum($(vHighHighN14), $(vCriticalMediumN14), $(vHighMediumN14), $(vCriticalLowN14), $(vHighLowN14)))), Owner, Age, [Last Observed], [Risk Factor], Urgency))

Re: Variables behind a button

Anonymous — Fri, 29 Jun 2018 16:05:30 GMT

I have discovered that using the sum(agrr(

it is not showing any Low or medium results in my chart, only critical and high?

they have data in the load but just aren't showing through that expression.

Any advice?

Re: Variables behind a button

sunny_talwar — Fri, 29 Jun 2018 16:08:56 GMT

Without seeing, nope... sorry