topic displaying field values as fields in chart table in QlikView

displaying field values as fields in chart table

Fri, 04 Feb 2011 11:57:14 GMT

Hi,

Actually i am having field of defectnames(i.e holes, edges, tears) in table. Defectname field display the list of holes, edges, tears. There is a data for holes, edges, tears.

Now i need to display that values(holes, edges, tears) as field in straight table. Based on click of particular id it should display its data.

I.e: ID Holes Edges Tears

1 20 20 25

2 10 5 15

and so on...

can you provide solution for this.

Thnks

displaying field values as fields in chart table

Fri, 04 Feb 2011 12:03:31 GMT

You can make it as Expression.

Do by if condition or Set analysis.

ex:

if( filedname = ' holes' , Filedname)

i hope this will work

displaying field values as fields in chart table

Fri, 04 Feb 2011 12:16:30 GMT

Thanks for quick reply,

my table having field name = defectname and in defectname field having defect.holes, defect.tear, defect.chips.

With this how can i write in your example.

I am new to QlikView. Please provide with me example.

Thanks

AW:displaying field values as fields in chart table

brenner_martina — Fri, 04 Feb 2011 12:19:44 GMT

Hi,

I did answer, right mouse click, chart, table, enter dimension, enter expression - ready!

AW:displaying field values as fields in chart table

Fri, 04 Feb 2011 12:31:12 GMT

Thnks for reply.

In expression what condition i need to write to get exact what i want.

Thnks