Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Srinivas
Contributor

Need only one row

Hi All,

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

How to do Could you please help on this.


Warm Regards,

Munna

Thanks,
Srinivas
6 Replies
Highlighted

Re: Need only one row

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

Highlighted
ecolomer
Honored Contributor II

Re: Need only one row

Can you explain more about your nedds?, please

Highlighted
Srinivas
Contributor

Re: Need only one row

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

Thanks,
Srinivas
Highlighted

Re: Need only one row

can you post a sample app?

Not applicable

Re: Need only one row

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... ?

Highlighted
anbu1984
Honored Contributor III

Re: Need only one row

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 ];