Problem in advanced SET analysis

[#1]

Dear All,

I am facing problem to write a exclude set analysis expression.

Please find the qlikview and excel attachmet.

Regards,

Debasmita

[rubenmarin]

Hi Debasmita

To retrieve the bills without the selected Item, you can use an expression like:

Count(DISTINCT {1<[Bill No]=E({$<Item_No={$(vItem)}>})>} [Bill No])

[Anonymous · Accepted solution]

Hi!

Can you try this?

count({<Item_Name=e(Item_Name), [Bill No]=e([Bill No])>}DISTINCT [Bill No])

KR

Elena

[agilos_mla]

Hi,

Simply try the following Expression that should return all the bills that excluding those linked to selection

=count(distinct {1<[Bill No]=E([Bill No])>}[Bill No])

Rgds,

Michael