Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mwerner87
New Contributor

Line Chart showing values separately

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


5 Replies
MVP
MVP

Re: Line Chart showing values separately

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

MVP
MVP

Re: Line Chart showing values separately

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


mwerner87
New Contributor

Re: Line Chart showing values separately

Hi,

thanks. good answer!

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

mwerner87
New Contributor

Re: Line Chart showing values separately

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))

vsudhakar
Contributor III

Re: Line Chart showing values separately

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

Community Browser