Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

one line chart instead of two line charts

Hello All,

Current i got  two Line charts,

1) First  chart as    Dimension: Time,Type

                            Measure: sum(distinct value)

2) second chart as Dimension :Time

                            Measure: count ( customer)

and then i place one chart over another chart.

so i want to known  is it possible to achieve same requirement in one chart instead of two charts ,

i mean the first expression should use two dimensions(Time,Type) and the second expression should use only one dimension (Time)

11 Replies
arulsettu
Honored Contributor III

Re: one line chart instead of two line charts

try this

count(<Type>customer)

kunkumnaveen
Contributor III

Re: one line chart instead of two line charts

Hi

count(<Type>customer)


will it wont consider Type dimension for second expression?

kunkumnaveen
Contributor III

Re: one line chart instead of two line charts

It is throwing me an expression error ......

kunkumnaveen
Contributor III

Re: one line chart instead of two line charts

Any more suggestions  plzz......

arulsettu
Honored Contributor III

Re: one line chart instead of two line charts

may be this

count({<Type>}customer)


or


count(Total <Type>customer)

kunkumnaveen
Contributor III

Re: one line chart instead of two line charts

It just ignoring Type dimension  for both the expressions ..

Re: one line chart instead of two line charts

Why Not Combo Chart? Using two expressions

Life is so rich, and we need to respect to the life !!!
kunkumnaveen
Contributor III

Re: one line chart instead of two line charts

combo ok ,but what about dimensions ..i need to use two dim for 1st exp and only 1 dim for 2nd exp...is it possible in combo

Re: one line chart instead of two line charts

I recommend you to create Group for first dim's then use another dim then choose expression then try.

Life is so rich, and we need to respect to the life !!!
Community Browser