topic Re: Count if data starts with F* in App Development

Count if data starts with F*

michak80 — Fri, 17 Sep 2021 20:42:13 GMT

Hello,

I have a column where have a lot of data starts with F*, M*, S*. I would like count unique data but only if starts with F*

I have tried below but I receive 0

Count({<ITL_LIST_ID = {'F0*'}>}ITL_LIST_ID)

Could you please help me?

Nicole-Smith — Fri, 17 Sep 2021 23:13:28 GMT

When using wildcards in set analysis, you need to wrap the string in double quotes " instead of single quotes.

MayilVahanan — Sat, 18 Sep 2021 01:51:25 GMT

For Unique count, you need to use Distinct along with Nicole suggestion.

Count({<ITL_LIST_ID = {"F0*"}>}distinct ITL_LIST_ID)

michak80 — Sat, 18 Sep 2021 06:11:42 GMT

@Nicole-Smith, @MayilVahanan Thank you very much! It works!

michak80 — Sat, 18 Sep 2021 09:24:20 GMT

Unfortunatly I have another problem 😞

I recieved all lists starts with F0% but I need to add additional requirment: if ITL_CODE = 'XXXX'.

So, I have now Count({<ITL_LIST_ID = {"F0*"}>}distinct ITL_LIST_ID) and I need to add new requirment

Sorry form my questions but I'm new in Qlik. I have some expericnce in SQL Oracle but in Qlik logic is different.

Thank you for understanding.

Kushal_Chawda — Sat, 18 Sep 2021 12:26:33 GMT

@michak80 try below

Count({<ITL_LIST_ID = {"F0*"},ITL_CODE ={ 'XXXX'}>}distinct ITL_LIST_ID)

michak80 — Sat, 18 Sep 2021 14:54:48 GMT