Using GetFieldSelections with Count function

[Smoke133]

I am new to Qlik Sense. I need to count the number of VIN's where the selected package inspected in a filter that is equal to the rejected sales code. In addition, I need to be able to count if more than one sales code is selected.

VIN | PackageInspected | RejectedSalesCode

TD849306 | MID,HDE,IME | IME

TD840345 | MID,HDE,KDF | MID

TD756034 | HDE,LDE,KDF | HDE

TD559293 | MID,HDE,IME | IME

TD885594 | IFK,IME,MID | IME

Sample 1

=Count({<[RejectedSalesCode] ={'IME'}>}[VIN])

Filter Panel (Package Inspected): IME

Resultes: 3

Sample 2

=Count({<[RejectedSalesCode] ={'IME','HDE'}>}[VIN])

Filter Panel (Package Inspected): IME,HDE

Resultes: 4

I try to use this code to count the VIN base of the PackageInspected filter panel, but it is not giving me a count.

=Count({<[RejectedSalesCode] ={'$(=GetFieldSelections(PackageInspected ))'}>}[VIN])

[AshutoshBhumkar]

Hello,

Try below expression.

=Count({<[RejectedSalesCode] ={"$(=Replace(GetFieldSelections(PackageInspected ),',','","'))"}>}[VIN])

Thanks,

Ashutosh

[Smoke133]

Hi Ashutosh,

Using this expression only gives me the count for the first package selected on the filter panel. I need it to count if more than one is selected, similar to sample 2.

[AshutoshBhumkar · Accepted solution]

Hi, Try below

Expression : =Count({<[RejectedSalesCode] ={"$(=Replace(Replace(GetFieldSelections(RejectedSalesCode),',','","'),' ',''))"}>}[VIN])

Are you selecting values from Package Inspected or RejectedSalesCode ?

Make changes as per the selection in Expression.

Thanks,
Ashutosh

[Smoke133]

Ashutosh,

I am selecting Package Inspected. I tested the expression and it looks like it is working. I am checking the data to confirm it is giving me the correct data. I will let you know how it goes.

Thank you for your help.

[Smoke133]

Ashutosh,

Thank you for your help. Everything looks good. One last question about the expression. I would like to add to it to prevent it from filtering the RejectedSalesCode when selected in a different filter panel?

I tried this, but it does not prevent it from being filtered if RejectedSalesCode  is selected in a filter panel

Expression : =Count({<[RejectedSalesCode] ={"$(=Replace(Replace(GetFieldSelections(Package Inspected),',','","'),' ',''))", $<[RejectedSalesCode]=>}[VIN])

Any suggestions?

[AshutoshBhumkar · Accepted solution]

Hello, 

If you want to ignore the selection of RejectedSalesCode then use the corrected expression.

=Count({<[RejectedSalesCode] ={"$(=Replace(Replace(GetFieldSelections(Package Inspected),',','","'),' ',''))"}, RejectedSalesCode =>}[VIN])

Thanks,

Ashutosh