topic Re: Ignore dimension for an expression in a Chart in QlikView

Ignore dimension for an expression in a Chart

rajeshvaswani77 — Sat, 27 Jun 2015 11:05:29 GMT

Hi Community,

I have a Line chart, Two Dimensions and two Expressions.

I want expression1 to consider only dimension1 and ignore dimension2, however expression2 must consider both of them.

Is there a way to achieve this, right now since expression1 is considering both the dimensions the chart is getting distorted.

I have linked table and two facts on either side. The dimensions and expressions belong to both the facts.

I have a solution where I can superimpose two charts and have transparency, however during export this will be an issue.

Have tried the dimensionality, but not able to make it work.

Any suggestions, please post.

thanks,

Rajesh Vaswani

Re: Ignore dimension for an expression in a Chart

sunny_talwar — Sat, 27 Jun 2015 11:48:57 GMT

‌Have you tried it with the Total qualifier? Try: Sum(TOTAL <Dimension1> Value) (you may need to replace Sum with what ever type of aggregation you are trying to do) This is for the expression 1 which only needs to consider Dimension1.

See if that works, if it doesn't would you be able to share a sample?

HTH

Best,

Sunny

Re: Ignore dimension for an expression in a Chart

sunny_talwar — Sat, 27 Jun 2015 12:08:38 GMT

Just to add, there is also a possibility to use an aggregate function, but will need to know what is your data looks like and what is the expected output. Aggregate might look like this:

Sum(Aggr(Sum(Value1), Dimension1))

Attaching a dummy application for you to see.

Best,

Sunny

Re: Ignore dimension for an expression in a Chart

svenkita — Mon, 29 Jun 2015 06:28:52 GMT

Sample screen shot

2 dimensions : year and month

Expression 1 is sum(sales) based on year and month

Expression 2 & 3 are based on the Year dimension only.

Sample file attached

hope this helps