topic Re: Multiple values per date in a diagram in QlikView

Multiple values per date in a diagram

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table with a date field and a value field.

Now I would like to display *all* values over date in a diagram.

I tried the line diagram but found that qlikView drops dates with multiple values for that date.

It would be ok to have a vertical bar for each date with the min and max value.

How can I achieve this?

Thank you very much,

Tobias

Re: Multiple values per date in a diagram

jhoef-pv — Fri, 05 Jan 2018 12:36:40 GMT

Hi,

you can put as dimension: field date and 2 expression: min(value) and max(value). But this bar show for each date with the min and max value and not display all values.

this chart bar in style-->Subtype Grouped

In Presentation --> Bar Setting can change bar distance and cluster distance.

Also you can change style --> Subtype to Stacked.

JPV