Count if data starts with F*

[michak80]

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]

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

[MayilVahanan]

Hi 

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

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

[michak80]

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

[michak80]

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]

@michak80  try below

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

[michak80 · Accepted solution]

@Kushal_Chawda Thank you!!!