topic Re: Distinct values not required in QlikView

Distinct values not required

priyarane — Wed, 02 Aug 2017 10:12:25 GMT

Hi Community,

I have data for ex like below

Type,Val

A,10

A,10

A,10

B,20

B,20

B,21

I need same as above in the straignt table, my observation is when I checked in the table box it is appearing like below

Type,Val

A,10

B,20

B,21

so How can I show the output in straght table like below

Type,Val

A,10

A,10

A,10

B,20

B,20

B,21

-Priya

Re: Distinct values not required

PrashantSangle — Wed, 02 Aug 2017 10:18:07 GMT

In your script add rowNo() while loading data.

Like

Load RowNo() as rowId,

* from Table;

In front end straight table take all field and In presentation tab Hide rowId column.

Regards,

Re: Distinct values not required

senpradip007 — Wed, 02 Aug 2017 10:25:43 GMT

Have a look at this.