Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Author

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
sunny_talwar

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

MK_QSL
MVP
MVP

Considering Buyer is the Dimension

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

stigchel
Partner - Master
Partner - Master

Try with

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

Kushal_Chawda

something like this

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

Not applicable
Author

Hi,

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

E(), its basically exclusion.

Regards,

Navdeep

Anonymous
Not applicable
Author

Thank you for your help everyone!

MK_QSL
MVP
MVP

I have also given the same expression !

Anonymous
Not applicable
Author

Excellent Manish, well done