Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: Variables behind a button

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

Capture.PNG

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

Capture.PNG

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

Capture.PNG

What am I missing?

Highlighted
sskiggs1
New Contributor III

Re: Variables behind a button

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

range sum.PNG

*Apologies, I mean't Medium and Critical

Re: Variables behind a button

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

Capture.PNG

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

sskiggs1
New Contributor III

Re: Variables behind a button

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

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))

sskiggs1
New Contributor III

Re: Variables behind a button

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.

NoLowMed.PNG

Any advice?

Re: Variables behind a button

Without seeing, nope... sorry