topic Problem in advanced SET analysis in QlikView

Problem in advanced SET analysis

Fri, 02 Jan 2015 12:09:30 GMT

Dear All,

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

Please find the qlikview and excel attachmet.

Regards,

Debasmita

rubenmarin — Fri, 02 Jan 2015 12:28:06 GMT

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 — Fri, 02 Jan 2015 12:31:30 GMT

Hi!

Can you try this?

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

Elena

agilos_mla — Fri, 02 Jan 2015 12:33:11 GMT

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