Set Analysis

[#1]

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

gwassenaar‌

Reddys310‌balrajahlawat‌jagan‌

[Gysbert_Wassenaar]

What!?

You'll have to explain the logic of that to me first. Why should selecting A not show A, but B and C. And why (B and C) and not for example (D and B)?

[Anonymous]

try like this?

Straight table -> Properties -> Dimension -> Edit your Product Dim and replace it with this:

=if(getfieldselections(Product)='A',

If(Product='B' or Product='C', Product), Product)

[Anonymous]

if this does not work, then try like this?

In script, add one more column of Product with new alias, like this?

Load,

Product,

Product as Product_List

from

Table;

then write this calculated dimension?

=if(getfieldselections(Product_List)='A',

If(Product='B' or Product='C', Product), Product)

[#5]

hi Balaraj

let me check and tell you

Thank you

Sai Madhu

[sunny_talwar]

I agree with Gysbert, we need to understand the logic behind seeing B and C when you select A. What happens when you select B? or C or D? You see them or see something else?

[Kushal_Chawda]

I think you want to compare the two different products or group of products. Then try with alternate states. Using alternate states you will be able to compare the different set of Products.

See the below links

Introduction to alternate states - The Qlik Fix! The Qlik Fix!‌

Alternate States Use-Cases

[reddy-s]

Hi Sai Madhu,

As Gysbert mentioned can you please provide more explanation! A sample qvf file should be helpful to solve the issue.

Thanks,

Sangram.

[#9]

Yes if i Select A  i want to See B and C ,, if i select B i want to see A And C Like that

[sunny_talwar]

Something like this?

But not sure why you wouldn't see D like in the above screenshot?