Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to dislplay all the fields

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: How to dislplay all the fields

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.

8 Replies

Re: How to dislplay all the fields

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.


talk is cheap, supply exceeds demand
MVP
MVP

Re: How to dislplay all the fields

Hi,

Can you elaborate with an example?

Regards,

Jagan.

Not applicable

Re: How to dislplay all the fields

thanks

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

Thanks

Pavan

Not applicable

Re: How to dislplay all the fields

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

Not applicable

Re: How to dislplay all the fields

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

MVP
MVP

Re: How to dislplay all the fields

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

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


talk is cheap, supply exceeds demand
Not applicable

Re: How to dislplay all the fields

Thanks

Community Browser