topic Re: How to output the value of another alternate state in QlikView

How to output the value of another alternate state

uacg0009 — Tue, 21 Jan 2014 08:53:38 GMT

Hi all,

I have some data and two lists like below:

one of list's alternate is inherited, another one is GROUP1 that I made.

now what I want is:

if I choose A from ITEM2 and then choose B from ITEM1, the result what I want to show is:

Because only VIP=1 and VIP=3 have bought both A and B, so the number is 2.

How to do it?

Thank you all!

Re: How to output the value of another alternate state

Anonymous — Tue, 21 Jan 2014 12:43:21 GMT

Changjun

I reckon from you data that not only VIP=1 and VIP=3, but also VIP=2, so reckon the number should be 3.

Is there something I am misunderstanding ?

Best Regards, Bill

Re: How to output the value of another alternate state

Tue, 21 Jan 2014 12:53:01 GMT

Changjun,

Did you try the basic :

count({<Group1 * Group2>} VIP) ?

Fabrice

Re: How to output the value of another alternate state

tresB — Tue, 21 Jan 2014 13:31:33 GMT

Try like:

=Count({<VIP=P({<ITEM=[GROUP1]::ITEM>})>}VIP)

Re: How to output the value of another alternate state

jerem1234 — Tue, 21 Jan 2014 13:57:07 GMT

See if attached is what you're looking for. The formula I wound up using was:

=count({$<VIP = p({$}VIP)>*<VIP = p({GROUP1}VIP)>}distinct VIP)

Hope this helps!

Re: How to output the value of another alternate state

uacg0009 — Wed, 22 Jan 2014 01:25:02 GMT

Hi Markham,

Thank you for your attention, because VIP=2 didn't buy ITEM A, so when I choose A from ITEM2 and B from ITEM1,

it didn't include VIP=2, so the number is 2.

Re: How to output the value of another alternate state

uacg0009 — Wed, 22 Jan 2014 01:39:11 GMT

Thank you Fabrice, but do you have any idea to output the column of ITEM2?

because I can't output the value of GROUP1.

Re: How to output the value of another alternate state

uacg0009 — Wed, 22 Jan 2014 01:41:16 GMT

Thank you tresesco, but could you have any idea to output the column of ITEM2?

because I can't output the value of GROUP1.

Re: How to output the value of another alternate state

uacg0009 — Wed, 22 Jan 2014 01:57:04 GMT

Thank you jerem, it is very useful for me.

But I also have a problem, if I don't want to concat the ITEM, do you have any idea to use other function to output the

column of ITEM?

Thank you very much.

Re: Re: How to output the value of another alternate state

tresB — Wed, 22 Jan 2014 05:01:14 GMT

You can use only() instead of concat in that case. PFA (i have just tweaked jerem1234 's example)

Re: How to output the value of another alternate state

uacg0009 — Thu, 23 Jan 2014 02:13:42 GMT

Thank you very much tresesco. only is ok for me.

But if I want to choose more than one ITEM, do you have any idea to show all the ITEM that what you choose?

Or there is impossible to do it??

Thank you~

Re: How to output the value of another alternate state

tresB — Thu, 23 Jan 2014 06:07:22 GMT

I don't like saying "Impossible". And here too I believe there would be a work around, possibly using synthetic dimension; pick/match. But that would probably be unnecessarily complex. Concat() is fine for that; you will get the values separated by a delimiter which makes sense for me . What makes you not using that function?

Re: How to output the value of another alternate state

uacg0009 — Thu, 23 Jan 2014 07:14:31 GMT

For a example, we create a normal table that don't use alternate state. And when we choose ITEM=A,B.

there will be two rows A and B, and show how many vips bought A and how many vips bought B.

"two rows" is important, that is what I want, but the method you and jerem1234 provided is so great and I learnt a lot

from that, so thank you very much and sorry for my serious questions again and again, because I want it better.

In our example, the first column used alternate state(GROUP1), the second column used inherited,

is there have a way to make the second column to show the ITEM like what I said above, not only one row?

Thank you so much!

Re: How to output the value of another alternate state

tresB — Thu, 23 Jan 2014 09:08:33 GMT

See, there is no association between different states. So it makes really no sense putting them in a single chart object. If you select A,B from Group1, and C from inherited, how would you like to see them? two rows for A and B, but one for C which is neither related to A nor B, so on which row? and then what about the count? row-wise ? Better the different state's values in different objects, may be list boxes and the count in text box.