topic Re: Using GetFieldSelections with Count function in App Development

Using GetFieldSelections with Count function

Smoke133 — Wed, 27 Oct 2021 23:53:24 GMT

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])

Re: Using GetFieldSelections with Count function

AshutoshBhumkar — Thu, 28 Oct 2021 06:31:18 GMT

Hello,

Try below expression.

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

Thanks,

Ashutosh

Re: Using GetFieldSelections with Count function

Smoke133 — Thu, 28 Oct 2021 20:01:58 GMT

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.

Re: Using GetFieldSelections with Count function

AshutoshBhumkar — Fri, 29 Oct 2021 03:40:40 GMT

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

Re: Using GetFieldSelections with Count function

Smoke133 — Mon, 01 Nov 2021 20:25:05 GMT

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.

Re: Using GetFieldSelections with Count function

Smoke133 — Fri, 05 Nov 2021 19:13:56 GMT

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?

Re: Using GetFieldSelections with Count function

AshutoshBhumkar — Fri, 05 Nov 2021 19:25:21 GMT

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