Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

displaying field values as fields in chart table

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

4 Replies
Not applicable
Author

You can make it as Expression.

Do by if condition or Set analysis.

ex:

if( filedname = ' holes' , Filedname)

i hope this will work

Not applicable
Author

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

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

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

Not applicable
Author

Thnks for reply.

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

Thnks