Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi, use Count(ColumnName) as measure and ColumnName as dimension.
Hi, use Count(ColumnName) as measure and ColumnName as dimension.
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.
Actually i had a lot of modes need to be count
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!!
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.
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
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
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
Hi - I can see the screen, cannot access the sheet.
Copied the values I see.
Hope this helps.