topic Re: Not include current selection in QlikView

Not include current selection

Anonymous — Thu, 16 Jul 2015 11:11:33 GMT

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

sunny_talwar — Thu, 16 Jul 2015 11:13:53 GMT

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 — Thu, 16 Jul 2015 11:17:19 GMT

Considering Buyer is the Dimension

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

stigchel — Thu, 16 Jul 2015 11:18:05 GMT

Try with

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

Kushal_Chawda — Thu, 16 Jul 2015 11:23:12 GMT

something like this

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

Thu, 16 Jul 2015 11:29:55 GMT

Hi,

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

E(), its basically exclusion.

Regards,

Navdeep

Anonymous — Thu, 16 Jul 2015 12:59:07 GMT

Thank you for your help everyone!

MK_QSL — Thu, 16 Jul 2015 14:01:30 GMT

I have also given the same expression !

Anonymous — Thu, 16 Jul 2015 14:12:10 GMT

Excellent Manish, well done