Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

possible chat

Hi All,

 

I have  4 measures like below

count({<level={'L1'}>}users)

count({<level={'L2'}>}users)

count({<level={'L3'}>}users)

count({<level={'L4'}>}users)

I want to show this in one chart so can anyone suggest which chat I can use?

hot to create a flag for this and use as single? any other suggestions.

Labels (2)
2 Solutions

Accepted Solutions
MayilVahanan

HI @soniasweety 

Dim: level

Exp: count({<level={'L1','L2','L3','L4'}>}users)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

Vegar
MVP
MVP

The choice of chart depends. Why do you want to present these four measures? Different charts can be better or worse depending on what kind of comparison they want to do.

But in general I would probably start of with some kind of bar chart. 

Vegar_1-1605514604419.png

 

         

View solution in original post

5 Replies
MayilVahanan

HI @soniasweety 

Dim: level

Exp: count({<level={'L1','L2','L3','L4'}>}users)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Vegar
MVP
MVP

The choice of chart depends. Why do you want to present these four measures? Different charts can be better or worse depending on what kind of comparison they want to do.

But in general I would probably start of with some kind of bar chart. 

Vegar_1-1605514604419.png

 

         

soniasweety
Master
Master
Author

Hi @MayilVahanan  , @Vegar 

I used Pie chart for this its working fine . but  if I select level  in listbox  chart is not reflecting .. is there anyway to reflect the chat if I select in filter ?

Vegar
MVP
MVP

Try using this expression. 

count({<level*={'L1','L2','L3','L4'}>}users)

 

If you look closely you will see that I used the technique in some of the bar charts on my earlier posted image.

soniasweety
Master
Master
Author

Thank you.

I tried this  aggr(count({<level={'L1','L2','L3','L4'}>}users),Level)    working fine.