topic Re: simple set analysis confusion in QlikView

simple set analysis confusion

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

hi all,

it was my understanding that using a 1 in set analysis will ignore any current selections i.e clicking on charts and what not will not affect the chart with the 1.

i have the below expression in 3 different charts (the variable represents 1,2,3) however when i click on one chart the other 2 show 'No Date to Display'

sum({1< Area = {'$(vArea_Top_1)'}>} Lane_1_Total)

the dimension is Area btw.

can someone explain where i'm going wrong?

Re: simple set analysis confusion

sunny_talwar — Tue, 29 Mar 2016 08:46:37 GMT

What is the definition of vArea_Top_1 variable?

Re: simple set analysis confusion

swuehl — Tue, 29 Mar 2016 08:47:16 GMT

Is this

$(vArea_Top_1)

using an expression that is influenced by user selections?

Re: simple set analysis confusion

Chanty4u — Tue, 29 Mar 2016 08:47:37 GMT

sum({{1}< Area = {'$(vArea_Top_1)'}>} Lane_1_Total)

Re: simple set analysis confusion

samuel_brierley — Tue, 29 Mar 2016 08:48:50 GMT

it results in 'Junction 6A M1, M25' which is set in the load script by this

let vArea_Top_1 = peek('Area',0, 'Top Area');

Re: simple set analysis confusion

Chanty4u — Tue, 29 Mar 2016 08:49:35 GMT

or else

sum({1< Area =e {'$(vArea_Top_1)'}>} Lane_1_Total)

Re: simple set analysis confusion

sunny_talwar — Tue, 29 Mar 2016 08:49:56 GMT

Selection in which field is causing this issue for you?

Re: simple set analysis confusion

Chanty4u — Tue, 29 Mar 2016 08:52:18 GMT

try this

sum({1<Area=E({$(vArea_Top_1)}>} Lane_1_Total)

Re: simple set analysis confusion

samuel_brierley — Tue, 29 Mar 2016 08:52:38 GMT

no ive checked that by using a text box purely with the variable and madew slection. the value didint change

Re: simple set analysis confusion

samuel_brierley — Tue, 29 Mar 2016 08:54:55 GMT

Hi Chanty,

unfortunately non of those work

Re: simple set analysis confusion

swuehl — Tue, 29 Mar 2016 09:01:36 GMT

Any other expressions used in that chart (maybe within a attribute / conditional?)?

Could you upload a small sample QVW that demonstrates the issue?

Re: simple set analysis confusion

samuel_brierley — Tue, 29 Mar 2016 09:27:33 GMT

not that i can see.

ive attached the QVD, the charts in question are the 3 bar charts at the top right.

thanks swuehl.

p.s im not on a licensed machine so if you dont mind please try and explain the solution

Re: simple set analysis confusion

swuehl — Tue, 29 Mar 2016 09:36:41 GMT

You are indeed using aggregations without that set identifier, you need to ignore selections in every aggregation, like

=sum({1< Area = {'$(vArea_Top_2)'}>} Lane_1_Total)/count( {1} distinct(Time))*6