Solved: Re: Distinct values not required - Qlik Community

priyarane · ‎2017-08-02

Hi Community,

I have data for ex like below

Type,Val

A,10

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

B,20

B,21

-Priya

PrashantSangle · ‎2017-08-02

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2017-08-02

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

senpradip007 · ‎2017-08-02

Have a look at this.