topic Re: Dividing a field into two in App Development

Dividing a field into two

berryons — Thu, 23 Apr 2020 14:28:46 GMT

Hi everybody! I have an application with many fields in it. One of these fields is CategoryNames. In CategoryNames, there are hundreds of category names. One of them is "Unsufficient info", and I want to watch it specifically. I want to create a pie chart, which shows two slides, one is "Unsufficient info" the other is "Others". Thus, I can follow the current ratio which is equal to number of Unsufficient info/all category names. How can I do this?

Re: Dividing a field into two

BalaBhaskar_Qlik — Mon, 27 Apr 2020 12:05:34 GMT

May be try with If clause, create a dummy dimension... use that dummy dimension in Pie chart to show the percentage.

In script..

If(Match(CategoryNames,'Unsufficint Info'),'Unsufficint Info','Others') as CategoryName_Dummy... use this in pie chart...

or use the, same kind of definition in measure to create two different percentages...

Re: Dividing a field into two

berryons — Thu, 21 May 2020 08:46:11 GMT

@BalaBhaskar_Qlik thank you for your answer. I found a solution by creating an extra field. A flag field which divides rows in two with values 0 and 1.