Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
garethct
Contributor

Not include current selection

Hi all,

I'm wanting to show all units apart from those that have been bought from buyer that is currently selected.

My expression although it is wrong is,

if(BUYER.B_NO = GetCurrentSelections , '', BRANCH_NAME)

Could anyone give me a hand please?

Thanks

Gareth

1 Solution

Accepted Solutions
Not applicable

Re: Not include current selection

Hi,

PFA the demo app, you can change the condition as required.

E(), its basically exclusion.

Regards,

Navdeep

View solution in original post

8 Replies

Re: Not include current selection

I am guessing you want to use this within some kind of expression, if that's right try this:

{<BUYER.B_NO = e(BUYER.B_NO)>} or

{<BUYER.B_NO -= p(BUYER.B_NO)>}

MVP
MVP

Re: Not include current selection

Considering Buyer is the Dimension

Count({<units = e(units)>}DISTINCT units)

Partner
Partner

Re: Not include current selection

Try with

if(BUYER.B_NO = GetFieldSelections(BUYER.B_NO),null(),BRANCH_NAME)

Re: Not include current selection

something like this

count({<BUYER.B_NO =e({<BUYER.B_NO={"=getfieldselections(BUYER.B_NO)"}>})>}BRANCH)

Not applicable

Re: Not include current selection

Hi,

PFA the demo app, you can change the condition as required.

E(), its basically exclusion.

Regards,

Navdeep

View solution in original post

garethct
Contributor

Re: Not include current selection

Thank you for your help everyone!

MVP
MVP

Re: Not include current selection

I have also given the same expression !

garethct
Contributor

Re: Not include current selection

Excellent Manish, well done