topic Ignoring selection in dimension in QlikView

Ignoring selection in dimension

Anonymous — Thu, 23 Sep 2010 22:43:20 GMT

Hi,

I have an application containing data for 4 years. Year is a field the user can select - but only one year at a time (Always one selected value).

I know how to use set analysis in expressions to show data from "not selected" years... But, in one chart I would like to show all years as dimension. How do I do that?

Thanks in advance

Nils

Ignoring selection in dimension

johnw — Thu, 23 Sep 2010 22:51:37 GMT

Like this, for example:

sum({<Year=>} Sales

Having nothing after the equals sign tells it to IGNORE selections in that field for the purpose of that expression. I believe that as long as you return a value for the Year, like the above would, that using Year as your dimension would give you that Year, even if it is excluded by the selections.

Ignoring selection in dimension

Thu, 23 Sep 2010 22:53:08 GMT

Hi there, you can accomplish this with set analysis, use year as a dimension for the disired chart and use similar expressions to the following:

sum( {$<Year = P({1}) >} Amount)

Ignoring selection in dimension

Anonymous — Thu, 23 Sep 2010 23:02:25 GMT

Hi,

This is correct if I need data from more than one year in EXPRESSION, but I need all years shown as DIMENSION.

Thanks for your quick answer (and to John as well ;-))

Best regards

Nils

Ignoring selection in dimension

johnw — Thu, 23 Sep 2010 23:09:48 GMT


nilsGC wrote:but I need all years shown as DIMENSION

Which is exactly what happens if you do what either of us said. See attached.

Ignoring selection in dimension

Anonymous — Thu, 23 Sep 2010 23:14:02 GMT

It works - not completly logical, but it works

Thank you, both 😉

Best regards

Nils

Ignoring selection in dimension

johnw — Thu, 23 Sep 2010 23:20:57 GMT

Yeah, I agree. It doesn't really make sense. It seems like we should be doing something with the dimension instead, since that's what we're trying to fix.

Ignoring selection in dimension

Thu, 23 Sep 2010 23:21:01 GMT

Hi Nils, i can't really think on a case where you need a chart with only dimensions and without any aggregation function, what john and I try to say, is that if you use the year as a dimension and you select all the years with set analysis, your chart will display and calculate the expression over all the years in you data model. Perhaps you can be a little more specific on your situation if this does not help you.

Regards

Ignoring selection in dimension

Thu, 23 Sep 2010 23:25:13 GMT

I guessed i typed slower than you guys on my last post. Actually I recommend that you always filter dimension values within set analysis, rather than in the dimension. If you do it with a calculated dimension your ability for sorting will be lost.

Regards

Re: Ignoring selection in dimension

KRS772 — Tue, 26 Feb 2019 14:30:54 GMT

How would you alter this to sum for only the most recent Date period (selected or not)? If you have all years selected but want the sum for only the most recent year?

Re: Ignoring selection in dimension

rafaeljmvicente — Fri, 09 Aug 2019 11:44:39 GMT

It might be too late in the game but we can contribute for the future anyway

Add 1 to the idea that was already shared, this will force it to ignore the selection you have in hand

Count({1<[location=>}Type)

Re: Ignoring selection in dimension

rafaeljmvicente — Fri, 09 Aug 2019 11:45:08 GMT

sum({1<Year=>} Sales will to the trick