topic Re: 2 dimension with 3 expression in QlikView

2 dimension with 3 expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi every one,

I want create a Line chart with 2 dimension ; Year & Month and 3 expression .

I want when i choose 2 years from year listbox , in chart i see 6 trends

Dimension axis show month of year and Expression axis show 6 trend line ; for each expression we have 2 trend line.

How can i do this ?

With Best Regards

Hamide

Re: 2 dimension with 3 expression

Gysbert_Wassenaar — Mon, 24 Oct 2016 12:50:05 GMT

That's not possible. A line chart can have only two dimensions and one expression or multiple expression with a single dimension. You'll have to either use two charts or combine the two dimensions into one: =DimA & '-' & DimB

Re: 2 dimension with 3 expression

stigchel — Mon, 24 Oct 2016 12:57:50 GMT

Hi Hamide,

If you want to see six lines, you can't do that with two dimensions and three expressions. You can use six expressions (or more when more years are selected) and use for example the following in each of the two sets of three:

1st set

Sum({<Year={'$(=Max(Year))'}>} Sales)

2nd set

Sum({<Year={'$(=Max(Year,2))'}>} Sales)

...