topic Re: how to use pie chart without value in App Development

how to use pie chart without value

lichang422 — Sat, 25 Nov 2017 16:33:08 GMT

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!!

Re: how to use pie chart without value

Ivan_Bozov — Sat, 25 Nov 2017 20:53:29 GMT

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

Re: how to use pie chart without value

Anonymous — Sun, 26 Nov 2017 07:50:09 GMT

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.

Re: how to use pie chart without value

lichang422 — Sun, 26 Nov 2017 15:53:09 GMT

Actually i had a lot of modes need to be count

Re: how to use pie chart without value

lichang422 — Sun, 26 Nov 2017 16:30:50 GMT

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!!

Re: how to use pie chart without value

Anonymous — Sun, 26 Nov 2017 21:20:33 GMT

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.

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 06:18:28 GMT

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

Re: how to use pie chart without value

Anonymous — Mon, 27 Nov 2017 06:28:16 GMT

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

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 07:30:21 GMT

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

Re: how to use pie chart without value

Anonymous — Mon, 27 Nov 2017 08:08:15 GMT

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

Copied the values I see.

Hope this helps.

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 09:24:14 GMT

Sorry i don't know how to upload file

So i made a link ,you can try to download it!!

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 09:24:42 GMT

Link

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

Re: how to use pie chart without value

shraddha_g — Mon, 27 Nov 2017 09:26:47 GMT

Uploading a Sample

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 09:30:24 GMT

You can check it!!

Re: how to use pie chart without value

Anonymous — Mon, 27 Nov 2017 09:32:58 GMT

Seems like something you we're after.
Anything else you need to develop?

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 09:41:19 GMT

Yes,Maybe i will create a new discuss for next problem

if you have interesting , you can help me

i have a data like below link

data.jpg - Google Drive

i want to make a chart like below link

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

Re: how to use pie chart without value

Anonymous — Mon, 27 Nov 2017 10:39:18 GMT

Hi - sure, will try to help . Please attache the dataset.

Re: how to use pie chart without value

lichang422 — Mon, 27 Nov 2017 11:04:05 GMT

i had made a new discuss , if you have interesting to help me

https://community.qlik.com/message/1389622#1389622

Thank you for your help!!