Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in advanced SET analysis

Dear All,

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

Please find the qlikview and excel attachmet.

Regards,

Debasmita

1 Solution

Accepted Solutions
elena888
Specialist
Specialist

Hi!

Can you try this?

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

KR

Elena

View solution in original post

3 Replies
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])

elena888
Specialist
Specialist

Hi!

Can you try this?

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

KR

Elena

agilos_mla
Partner - Creator III
Partner - Creator III

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