topic Multidimension chart in QlikView

Multidimension chart

Mon, 14 Jan 2013 15:03:47 GMT

Hello

is it possible to make LINE chart like this in QV

thanks

Re: Multidimension chart

Mon, 14 Jan 2013 15:07:26 GMT

Change the axis for your second expression:

Re: Multidimension chart

Tue, 15 Jan 2013 09:53:44 GMT

Thanks

but by description LINE type chart can be with 2 dimensions. I my example are three dimensions: first,second and dates(x axis). Can this chart be made with QV ?

thanks

Re: Multidimension chart

martin59 — Tue, 15 Jan 2013 09:57:18 GMT

Hi,

I think you make a mistake.

You have one dimension (Date) and two expressions (wich are shown on different axis).

Hope that helps you,

Martin Favier

Re: Multidimension chart

Tue, 15 Jan 2013 14:01:08 GMT

That's not true. In a line graph you can technically have as many expressions as you want, it would just look bad. The graph you want has two expressions and one dimension. Take a look at the attached example. It may make it clearer for you.

Re: Multidimension chart

Thu, 17 Jan 2013 09:22:57 GMT

Hello

Its become clearer.

Next issue: in table for chart are several same expression values (several records) with the same date(Dates dimension). When using SUM - chart is fine, but i don't need get summary values.

How to take only ONE record value from the same dates records and therefore not use SUM ?

Thanks

Re: Multidimension chart

Thu, 17 Jan 2013 10:10:12 GMT

Hi,

Use distinct keyword in your expression.. For example you are having several policy id's in your system, and many of them are repeatative also, so now for taking out the total count of policy id's we should use

COUNT(DISTINCT POLICY_ID)

hope this helps

Re: Multidimension chart

Thu, 17 Jan 2013 10:12:54 GMT

with respect to your screen shot, it can be count(distinct units)

Re: Multidimension chart

Fri, 18 Jan 2013 12:28:47 GMT

Hello

Issue closed.

Thanks.