Yet another Count If {Field} = 'True'

[#1]

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.

[sunny_talwar · Accepted solution]

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

[#3]

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.

[#4]

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.