Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
lichang422
Not applicable

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

Tags (1)
1 Solution

Accepted Solutions
Ivan_Bozov
Not applicable

Re: how to use pie chart without value

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

17 Replies
Ivan_Bozov
Not applicable

Re: how to use pie chart without value

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

krzysztof_toman
Not applicable

Re: how to use pie chart without value

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
Not applicable

Re: how to use pie chart without value

Actually i had a lot of modes need to be count

lichang422
Not applicable

Re: how to use pie chart without value

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

krzysztof_toman
Not applicable

Re: how to use pie chart without value

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
Not applicable

Re: how to use pie chart without value

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

krzysztof_toman
Not applicable

Re: how to use pie chart without value

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
Not applicable

Re: how to use pie chart without value

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

krzysztof_toman
Not applicable

Re: how to use pie chart without value

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

Copied the values I see.

Hope this helps.