topic Re: Ignoring 1st Dimension in a chart in QlikView

Ignoring 1st Dimension in a chart

ingoniclas — Wed, 14 Mar 2018 18:08:56 GMT

Hi there,

I have a chart showing sales per product along a time axis, see below. It has the following dimensions and expressions:

1st Dimension: MonthYear

2nd Dimension: Product

Expression: sum(sales)

Now I want the 1st dimension 'MonthYear' to be ignored when I select a product that is linked to MonthYear in the data model. I have tried to use a set analysis as expression, but I couldn't make it work. Any help would be appreciated. Many thanks!

Re: Ignoring 1st Dimension in a chart

Chanty4u — Wed, 14 Mar 2018 18:13:37 GMT

tried this?

sum({$<MonthYear=>}Sales)

Re: Ignoring 1st Dimension in a chart

Chanty4u — Wed, 14 Mar 2018 18:15:07 GMT

or this

Sum(TOTAL <MonthYear> Value)

Re: Ignoring 1st Dimension in a chart

sunny_talwar — Wed, 14 Mar 2018 18:21:33 GMT

May be this

Sum(sales) + Sum({1} 0)

Re: Ignoring 1st Dimension in a chart

ingoniclas — Wed, 14 Mar 2018 18:31:06 GMT

Nope, none of this works. However, I forgot to mention that product and MonthYear are inked with a combined key in the data model. So I wonder if there is a solution like I am looking for at all.

Re: Ignoring 1st Dimension in a chart

sunny_talwar — Wed, 14 Mar 2018 18:33:26 GMT

Are you looking to ignore selection in Product field? May be this

Sum({<Product>}sales)

Re: Ignoring 1st Dimension in a chart

Nagaraju_KCS — Wed, 14 Mar 2018 18:33:55 GMT

Ignore all selections except some specific fields using Set Analysis

Re: Ignoring 1st Dimension in a chart

ingoniclas — Wed, 14 Mar 2018 18:36:05 GMT

This works in the way that the MonthYear dimension is static, however, it cuts away all the sales prior to the first month where product and MonthYear are linked 😞

Re: Ignoring 1st Dimension in a chart

sunny_talwar — Wed, 14 Mar 2018 18:37:37 GMT

I think you are looking for this

Sum({<Product>}sales)

Re: Ignoring 1st Dimension in a chart

Qrishna — Wed, 14 Mar 2018 21:19:05 GMT

Check this out.

Note : manipulate the color of the line(make it white) ! for the 'Not Active' Product, in case you want to see the line only for the selected product,

Re: Ignoring 1st Dimension in a chart

ingoniclas — Thu, 15 Mar 2018 11:27:18 GMT

Nope.

Re: Ignoring 1st Dimension in a chart

sunny_talwar — Thu, 15 Mar 2018 11:31:51 GMT

How about this?

Sum({<Product>}sales) + Sum({1} 0)

Re: Ignoring 1st Dimension in a chart

ingoniclas — Thu, 15 Mar 2018 11:39:44 GMT

That's it! A great general scheme for these kind of challenges! Thanks Raju and everyone else for their help!

For all those interested: I used the following expression and it worked:

sum({$<[$(=Concat({1<$Field-={'MonthYear'}>}distinct $Field,']=,[')&']=')>} Sales)