topic Re: Selections in QlikView

Selections

Thu, 30 May 2013 07:26:38 GMT

If I select data in one field how to show the data from another related field in a text object .Please help me write the condition

Regards

Murali Krishna

Re: Selections

er_mohit — Thu, 30 May 2013 07:29:47 GMT

if you select one field

then in text object write

=count(related field)

Re: Selections

Thu, 30 May 2013 07:36:38 GMT

If(Getselectedcount(field)>0,count(related field))

This expression is working fine and giving me the count.However i want the data of the related field to be displayed.

Please help

Regards

Murali

Re: Selections

Thu, 30 May 2013 07:38:07 GMT

Hi,

Just write the related field in the text box.

Hope it ll work.

Re: Selections

Thu, 30 May 2013 07:41:03 GMT

Thanks nazneen

It is working if i select a single data

If I am selecting more than one data it is not working and giving me blank

Regards

Murali

Re: Selections

Sokkorn — Thu, 30 May 2013 07:45:30 GMT

Hi Murali,

Did you try this yet

Concat(Field,',') or Concat(DISTINCT Field,',')?

Regards,

Sokkorn

Re: Selections

Sokkorn — Thu, 30 May 2013 07:46:57 GMT

GetFieldSelections(Field) Or

GetFieldSelections(Field,';')

Re: Selections

er_mohit — Thu, 30 May 2013 07:48:44 GMT

Try this

=Concat(DISTINCT Sale,',')

Re: Selections

Thu, 30 May 2013 08:12:19 GMT

Thanks Mohit

It is working now.

Re: Selections

Thu, 30 May 2013 08:13:19 GMT

Thanks cheav

It is working now.