Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
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
Hello,
Try below expression.
=Count({<[RejectedSalesCode] ={"$(=Replace(GetFieldSelections(PackageInspected ),',','","'))"}>}[VIN])
Thanks,
Ashutosh
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.
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
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.
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?
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