topic Need only one row in QlikView

Need only one row

Srinivas — Sat, 06 Dec 2014 13:18:17 GMT

Hi All,

I need only one row in this screen shot in edit script level.

How to do Could you please help on this.

Warm Regards,

Munna

Re: Need only one row

MarcoWedel — Sat, 06 Dec 2014 13:57:48 GMT

Can't open link, please include image in your post.

Re: Need only one row

ecolomer — Sat, 06 Dec 2014 13:59:23 GMT

Can you explain more about your nedds?, please

Re: Need only one row

Srinivas — Sat, 06 Dec 2014 16:37:13 GMT

Hi Marco,

Thanks for your response in my screen shot have two rows, So in that we need only one row,Here have all columns(Rows Values) are same expect PROD_DESC. in that PROD_DESC we need only one row values...

in my script level i used maxstring function but it's not work.

Regards

Munna

Re: Need only one row

MarcoWedel — Sat, 06 Dec 2014 16:41:54 GMT

can you post a sample app?

Re: Need only one row

Sat, 06 Dec 2014 18:03:19 GMT

hey Munna..

Nor your screenshot is visible neither is your question very clear..

you want only one row to appear out of 2 rows ?

or for a specific column , you want only one row data to appear... ?

Re: Need only one row

anbu1984 — Mon, 08 Dec 2014 05:55:10 GMT

Group by all the fields except PROD_DESC

Load Field1,Field2,MaxString(PROD_DESC) As PROD_DESC Group By Field1,Field2;

Load * Inline [

Field1,Field2,PROD_DESC

1,A,aaa

1,A,bbb

1,B,aaa

1,B,bbb ];