topic Re: Set Analysis in QlikView

Set Analysis

Fri, 18 Mar 2016 07:35:24 GMT

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‌

Re: Set Analysis

Gysbert_Wassenaar — Fri, 18 Mar 2016 07:43:23 GMT

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)?

Re: Set Analysis

Anonymous — Fri, 18 Mar 2016 07:54:16 GMT

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)

Re: Set Analysis

Anonymous — Fri, 18 Mar 2016 07:56:45 GMT

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)

Re: Set Analysis

Fri, 18 Mar 2016 08:02:38 GMT

hi Balaraj

let me check and tell you

Thank you

Sai Madhu

Re: Set Analysis

sunny_talwar — Fri, 18 Mar 2016 08:07:52 GMT

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?

Re: Set Analysis

Kushal_Chawda — Fri, 18 Mar 2016 08:27:26 GMT

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

Re: Set Analysis

reddy-s — Fri, 18 Mar 2016 09:25:38 GMT

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.

Re: Set Analysis

Fri, 18 Mar 2016 09:29:11 GMT

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

Re: Set Analysis

sunny_talwar — Fri, 18 Mar 2016 09:38:37 GMT

Something like this?

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

Re: Set Analysis

Fri, 18 Mar 2016 10:13:18 GMT

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

Re: Set Analysis

sunny_talwar — Fri, 18 Mar 2016 10:14:49 GMT

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

Re: Set Analysis

reddy-s — Fri, 18 Mar 2016 17:01:04 GMT

Hi Madhu,

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

Thanks,

Sangram.