topic Yet another Count If {Field} = 'True' in QlikView

Yet another Count If {Field} = 'True'

Wed, 23 Sep 2015 20:52:39 GMT

Hi, good afternoon.

So, I am new to Qlik Sense, and for the past hours i have been trying to do a simple Count([In Scope] = 'TRUE') in a Pie Chart Measure expression, but I cant make it work. The field contains a boolean expression but its actually a string.

I have seen many examples, usually something like Count({<[In Scope] = {'TRUE'}>} [In Scope]) but doesnt work either.

I know this is something really basic, but looks like i cant make it work.

Thank you,

Regards.

Re: Yet another Count If {Field} = 'True'

sunny_talwar — Thu, 24 Sep 2015 02:59:54 GMT

I see nothing wrong with your syntax here -> Count({<[In Scope] = {'TRUE'}>} [In Scope]). May be if you can provide a sample data we can help you with the visualization.

Best,

Sunny

Re: Yet another Count If {Field} = 'True'

Thu, 24 Sep 2015 14:16:06 GMT

Thank you for your time Sunny.

I'm attaching the qvf file and the excel file from where i get the data.

I'm trying to select all the devices that are In Scope 'True', grouped by customer (Chargeback Code). I tried Count({<[In Scope] = {'TRUE'}>} [In Scope]) but the chart window shows a text saying that the chart cant be displayed because it only cointains negative numbers or null.

Regards.

Re: Yet another Count If {Field} = 'True'

Thu, 24 Sep 2015 15:06:00 GMT

Ah i think i found the solution. All i had to do was replace 'TRUE' with '0', and 'FALSE' with '-1'.

I dont understand why would Qlik Sense would replace the data, possibly recognized that the field contains boolean information?

Anyway, case closed.

Thank you,

Regards.