Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

Hi All,

I have an a Product Table if i want select the 'A' product...then I want to get the information only  'B'  And  'C' Product Data as show in the below Picture .. How to Write the Scripting or Which Condition I want to use it

111.png

gwassenaar

Reddys310balrajahlawatjagan

12 Replies
Not applicable
Author

yes Like that only... can u give any example

sunny_talwar

The expression I used is this:

=If(GetSelectedCount(Product) > 0,

Sum({1<Product = e(Product)>} sales),

Sum(Sales))

The application is attached with my previous post

reddy-s
Master II
Master II

Hi Madhu,

As Sunny Mentioned the e() function should help you in this case.

Thanks,

Sangram.