topic How to pick one member from a list? in QlikView

How to pick one member from a list?

Wed, 04 Jul 2012 10:56:26 GMT

Hi All,

I have a list which contains A1, A2, A3 and i have to display them individually in different charts. how do i do that?

Re: How to pick one member from a list?

Wed, 04 Jul 2012 11:02:00 GMT

if (Field_name='A1')

you can use if formula

for ex: sum (if (Field_name='A1'), Field_name)

if you explain as detailed we can help you

best regards

Re: How to pick one member from a list?

Wed, 04 Jul 2012 11:04:37 GMT

Hi,

if you are using this list as dimension just put a calculated dimension like this->

=if( List = 'A1' ,List)

and suppress the null values then you will get data in that chart only for A1.

Re: How to pick one member from a list?

Wed, 04 Jul 2012 11:06:10 GMT

Hey guys,

Thanks for replying..

But both of the above doesn't solve my problem..

My problem is that i cannot refer to the list by the field name for an example 'A1' here..

I want to get it by position or something like that..because there are about six lists containing different field names and i am using the same object for all of them..

e.g.

RM1 has AM7, AM9, AM12,.... so on

RM2 has AM14, AM22, AM45..so on

RM6 has AM67, AM56... so on