topic Re: I Want see single row in QlikView

I Want see single row

kulasekhar — Fri, 03 Mar 2017 08:00:09 GMT

Hi All,

Bellow pivot table i had one ITEM_NUMBER have 1 or more SPECIFICATION_NUMBER and one SPECIFICATION_NUMBER have 3 or more ITEM_NAME.

http://

I want to see single row.

Please give me idea.

Thanks

Sekhar.

Re: I Want see single row

Anil_Babu_Samineni — Fri, 03 Mar 2017 08:57:25 GMT

You have Item_Name is different different names. So then? And you want to keep 81 and 87 too?

Re: I Want see single row

tresB — Fri, 03 Mar 2017 09:17:52 GMT

For ITEM_NAME column, try expression : MaxString(ITEM_NAME)

Re: I Want see single row

kulasekhar — Fri, 03 Mar 2017 10:08:04 GMT

Hi Tresesco,

For ITEM_NAME column, try expression : MaxString(ITEM_NAME)

For SPECIFICATION_NUMBER also same expression work or not.

Thanks a lot

sekhar

Re: I Want see single row

avinashelite — Fri, 03 Mar 2017 10:12:40 GMT

It works try like this

MaxString(SPECIFICATION_NUMBER )

Re: I Want see single row

Fri, 03 Mar 2017 10:13:55 GMT

Use a straight table?

Re: I Want see single row

kulasekhar — Fri, 03 Mar 2017 10:49:12 GMT

Thanks Avinash

Re: I Want see single row

kulasekhar — Fri, 03 Mar 2017 14:07:20 GMT

Hi Avinash,

For DATE field how can sort like min or max.

Thanks

Sekhar

Re: I Want see single row

avinashelite — Fri, 03 Mar 2017 15:19:16 GMT

Sorting or you want the min or max?

if its sorting then go to chart properties and Sort >select feild > numeric > and select ASC/DESC

hope this helps you

Re: I Want see single row

kulasekhar — Mon, 06 Mar 2017 07:33:13 GMT

Hi Avinash,

I want the Minstring or Maxstring. Mine it's working Minstring in expression. But Maxstring it's not working.

Thanks

Sekhar.

Re: I Want see single row

avinashelite — Mon, 06 Mar 2017 07:40:06 GMT

Could start a New thread for the same