topic Re: Table Help Required in QlikView

Table Help Required

tahirkhalil — Wed, 25 Nov 2020 16:16:04 GMT

HI Gurus,

I need an urgent help from you. I want to create the pivot/straight table for some text data - Can someone see the attached file and suggest how to create this kind of table?

Regards,

Re: Table Help Required

kumarkp412 — Thu, 28 Jul 2016 08:09:15 GMT

Hi Thair,

Based on the attachment and requirement in the secound, you can use the pivot table to make it.

For your reference see the attached QVW

Thanks

Kumar

Re: Table Help Required

kamielrajaram — Thu, 28 Jul 2016 08:10:26 GMT

Hi,

Hope this helps

Regards

Kamiel

Re: Table Help Required

danansell42 — Thu, 28 Jul 2016 08:17:02 GMT

Please find attached

Re: Table Help Required

tyagishaila — Thu, 28 Jul 2016 09:54:50 GMT

Expression: if(TaskID,'X','')

Dimension: All other fields in Dim and manage it accordingly (Columns/Rows)

Re: Table Help Required

tahirkhalil — Thu, 28 Jul 2016 10:27:18 GMT

That's great - but how to add Image_ID here in this pivot?

Re: Table Help Required

kamielrajaram — Thu, 28 Jul 2016 11:53:50 GMT

Try adding The following as a dimension

aggr(sum(DISTINCT Task_Image_ID),Address)