topic Re: graph with 3 dimensions in QlikView

graph with 3 dimensions

Fri, 25 Oct 2013 09:21:00 GMT

hi all,

how can i create a graph with 3 dimension?

i have:

2 salesman

2 years (2013,2012)

days (for month to date - 2013 and 2012)

and sales as expression

on OX have to be the days (1 2 3....24)

and i want to see the evolution for 4 lines (salesman 1 2013, salesman 1 2012,salesman 2 2013, salesman 2 2012)

in conclusion, i want to make comparatives between salesmen but with an eye also on last year the same period

thanks

cosmin

Re: graph with 3 dimensions

Gysbert_Wassenaar — Fri, 25 Oct 2013 09:26:14 GMT

Create a calculated dimension with four values by concatenating Year and Salesman: =Year & '-' & Salesman. Use that calculated dimension instead in the chart.

Re: graph with 3 dimensions

Fri, 25 Oct 2013 09:29:58 GMT

thanks, it works

so simple but so difficult if you are a beginner

many thanks again

cosmin