Multidimension chart

[#1]

Hello

is it possible to make LINE chart like this in QV

thanks

[#2]

Change the axis for your second expression:

[#3]

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

[martin59]

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

[#5]

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.

[#6]

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

[#7]

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

[#8]

OR

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

[#9]

Hello

Issue closed.

Thanks.