Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Combo or Line Chart with More Than 15 Measures.

Hi All,

I would like to ask you how to show measures in QSense if i have 20 measures (20 GROUP_CLASS),

and i will show it in one line chart or combo chart. and I use filter GROUP_CLASS,

if I unselect all, then it would appear all line.

and if I select some GROUP_CLASS, then only a few line of GROUP_CLASS that will appear.

i use expression =>  sum(distinct If([GROUP_CLASS] = 'G1' ,sales)).

is there someone have this experience use other extension or have a better solution?

Regards,

Ted

Tags (1)
5 Replies
phaneendra_kunc
Valued Contributor III

Re: Combo or Line Chart with More Than 15 Measures.

is there any reason not to add GROUP_CLASS as dimension and sum (sales) as expression?

Additionally you can add GROUP_CLASS as listbox/filter in the UI to filter the data.

Not applicable

Re: Combo or Line Chart with More Than 15 Measures.

Hi Phaneendra,

i have added GROUP_CLASS in filter, i wanna show sales by group_class by yearmonth.

phaneendra_kunc
Valued Contributor III

Re: Combo or Line Chart with More Than 15 Measures.

Some thing like this?

6-23-2015 5-00-48 PM.png

Not applicable

Re: Combo or Line Chart with More Than 15 Measures.

I enclose screenshoot below: groupclass.png

phaneendra_kunc
Valued Contributor III

Re: Combo or Line Chart with More Than 15 Measures.

I don't see a reason why u can not use Time and Group Class as dimensions and sum(sales) as expression in line chart.

What made you to write individual expressions for each group class?