Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

how to use pie chart without value

i had a data with some string , i want to show how many times string was shown by pie chart(for example the below table)

i want to count "Disconnect" & "Emergency" values and ratio

Thanks!!

sample.jpg

1 Solution

Accepted Solutions
Ivan_Bozov
Luminary
Luminary

Hi, use Count(ColumnName) as measure and ColumnName as dimension.

vizmind.eu

View solution in original post

17 Replies
Ivan_Bozov
Luminary
Luminary

Hi, use Count(ColumnName) as measure and ColumnName as dimension.

vizmind.eu
Anonymous
Not applicable

Hi,

do you want to count "Disconnect" & "Emergency" only and avoid counting the rest of the values within that variable? Or are these two the only values there are?

Kind regards,

Chris.

lichang422
Creator
Creator
Author

Actually i had a lot of modes need to be count

lichang422
Creator
Creator
Author

Sorry , i  am a newbie!!

So i'm not sure how to use the command code

i want to count columnName is "value"

So i made a command code by use count(value) as measure and value as dimension like as below picture

How could i fix it ?? sorry stupid problem!!

sample.jpg

Anonymous
Not applicable

Hi Shih,

when you finish data loading procedure you need to go to "application" instead "data load editor" (the screen you;re sharing".

This video will help you with first visualization:

https://www.qlik.com/us/products/qlik-sense/getting-started

Some tutorial on pie chart (4min20sec)

https://www.youtube.com/watch?v=ylCSNEr_93s

If it will not help share a sample file that I'll post a solution.

Kind regards,

Chris.

lichang422
Creator
Creator
Author

Sorry i had do my best !!

Please help me to made a sample , Thank you!!

below link is my sample file(xlsx)

https://drive.google.com/open?id=1nHWx4229WTPIPvCRdROpSo_uAl65g_2N

step1.jpg

step2.jpg

step3.jpg

Anonymous
Not applicable

If you need to count all that will make the analysis easier.

If some - a bit of set analysis will be required.

Her is some example you can use as an analogy for your query.

Please mark solved if this solves the issue.

Kind regards,

Chris

lichang422
Creator
Creator
Author

Thank you for your support !!

Maybe I think too hard , I directly try to push value to dimension & measure !!

Count(Measure.value)

It is success , It is no matter with measure which is not must be value!!

Thank you  Chris

未命名.jpg

Anonymous
Not applicable

Hi - I can see the screen, cannot access the sheet.

Copied the values I see.

Hope this helps.