how to using getcurrentselections and put in conditional?

[#1]

Hi All.

I have data it looks like this

 

And already integrated with filter pane where the condition is =if(Status='Pending', Brand) … only show Brand where status is pending.

When I select Brand A. I want the table will show Pending and Approve with brand is selected. Currently it only show pending.

Already tried with

Count({1<Status=, Brand=getcurrentselections(Brand) >} Status)  and not yet get luck

how to use getcurrentselections in conditional?

thanks

[sunny_talwar · Accepted solution]

Can you try this expression for your filter object

Aggr(Only({<Status = {'Pending'}>} Brand), Brand)

[#3]

Thanks Sunny for reply

already try and test the expression, seems ok and ...

have a problem or bug for qliksense ...

when i choose Brand C, it work as expected

then i choose brand C again for unselect

and give undesired result for filter pane it's still green color even though it's not unselected

i've already tested the filter pane for any kind of input(selected)... and having bug and giving undesired result for it's filter pane it's self

already attach the qvf files

how to fix this?

[sunny_talwar]

I guess you just need to click on the green tick mark to finalize your selections.

[#5]

feels like awkward for me ...

for the filter pane object view ...

thanks Sunny for your time