Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

priyarane
Contributor III

Distinct values not required

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

1 Solution

Accepted Solutions

Re: Distinct values not required

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,

Regards,
Prashant Sangle
2 Replies

Re: Distinct values not required

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,

Regards,
Prashant Sangle
senpradip007
Valued Contributor III

Re: Distinct values not required

Have a look at this.