topic How to dislplay all the fields in QlikView

How to dislplay all the fields

Thu, 25 Sep 2014 10:50:34 GMT

Hi Friends,

I have created a pivot table with some fields and caluculated a measure from a table.

I want all the fields from the original table into a text box, if the user clik on any value of measrue.

Thanks

Re: How to dislplay all the fields

Gysbert_Wassenaar — Thu, 25 Sep 2014 10:56:06 GMT

Try using the getcurrentselections() function. If you click on a value in an expression column in a chart then the dimension values of that row are selected.

Re: How to dislplay all the fields

jagan — Thu, 25 Sep 2014 10:58:56 GMT

Hi,

Can you elaborate with an example?

Regards,

Jagan.

Re: How to dislplay all the fields

Thu, 25 Sep 2014 11:02:40 GMT

thanks

But I want all the fields of original table not fields only present in the pivot table.

Thanks

Pavan

Re: How to dislplay all the fields

Thu, 25 Sep 2014 11:07:20 GMT

Hi Jagan

Lets say I have a table with fields A B C D amount.

I added only A B and Amount.

Now I created a text box where I want all the fields A B C D when I clik on Amount.

Thanks

Re: How to dislplay all the fields

Thu, 25 Sep 2014 11:31:16 GMT

Hi Gysbert

My problem is like this

Lets say I have a table with fields A B C D amount.

I added only A B and Amount.

Now I created a text box where I want all the fields A B C D and there values when I clik on Amount.

The expression =concat(distinct FieldValue($Field,ValueLoop(1,$(=count($Field)))),';') is static.

Please help.

Thanks

Re: How to dislplay all the fields

jagan — Thu, 25 Sep 2014 11:44:54 GMT

Hi Pavan,

Use Concat()

='A Values : ' & Concat(DISTINCT A, ',') & chr(10)

'B Values : ' & Concat(DISTINCT B, ',') & chr(10)

'C Values : ' & Concat(DISTINCT C, ',') & chr(10)

'D Values : ' & Concat(DISTINCT D, ',')

Hope this helps you.

Regards,

Jagan.

Re: How to dislplay all the fields

Gysbert_Wassenaar — Thu, 25 Sep 2014 12:34:36 GMT

=$(=concat(chr(39)&$Field&': '&chr(39) & ' & ' & 'concat(distinct [' & $Field & '],' & chr(39) & ';' & chr(39) & ')' , ' & chr(10) & ' ))

Re: How to dislplay all the fields

Thu, 25 Sep 2014 13:18:08 GMT

Thanks