Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to make a pie chart that shows the percentage that is yes and no. Moreover, in my data I have a column for UserInitiated where the data is simply either yes or no. How would i turn this data into a pie chart in Qlik? Any help would be appreciated.
Thanks
Hi - The 'UserInitiated' would be your dimension. But what exactly do you want to convey as the size of the pie slice ? # customers ? % of revenue ?
you can easily create an expression like: sum(1) will just count the rows in your data with each , but you may want more (or you may not) logic than that.
maybe
dimension UserInitiated
expression count(UserInitiated )
flag relative if you want %
The size of the pie slices would be the percentage of disruptions that were User Initiated. So from the column in the data, the percentage that is yes and the percentage that is no.
Data looks as such:
UserInitiated
Yes
Yes
No
Yes
etc...