topic Re: Line Chart showing values separately in QlikView

Line Chart showing values separately

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

i created a line chart with an time dimension and 4 formulas.

COUNT({CompiGroup1}Text) --> visualization = line

COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text)) --> visualization = only values

COUNT({CompiGroup2}Text) --> visualization = line

COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text)) --> visualization = only values

It's showing the values for each alternate states in the same graph. my requirement is to have it separated.

Is there any grouping function? (one Group for each alternate state)

Thanks

Re: Line Chart showing values separately

sunny_talwar — Mon, 07 Mar 2016 16:41:57 GMT

Not sure I understand what you are looking for, do you have a sample you can share?

Re: Line Chart showing values separately

swuehl — Mon, 07 Mar 2016 17:00:06 GMT

Try only two expressions:

Dual(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text)), COUNT({CompiGroup1}Text) ) --> visualization = line and values on data points

Dual( COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text)), COUNT({CompiGroup2}Text)) --> visualization = line and values on data points

Re: Line Chart showing values separately

Anonymous — Tue, 08 Mar 2016 09:07:11 GMT

Hi,

thanks. good answer!

It's working fine, unless I'm missing the starts points for both graphs, any idea?

Re: Line Chart showing values separately

Anonymous — Tue, 08 Mar 2016 09:14:32 GMT

finally I got it. thanks

DUAL(IF(ISNULL(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text))), '',COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text))),COUNT({CompiGroup1}Text))

Re: Line Chart showing values separately

Anonymous — Tue, 08 Mar 2016 09:15:38 GMT

Dual(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text)), COUNT({CompiGroup1}Text) ) --> visualization = line and values on data points

Dual( COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text)), COUNT({CompiGroup2}Text)) --> visualization = line and values on data points