Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Full Table in Straight Chart


hey guys,

i am trying to use Straight Chart to show full table data as it is.But this chart is only showing me the distinct records but I need to show the full table as it is.

How i can achieve this,

Thanks in advance.

1 Solution

Accepted Solutions
marcus_sommer

Then you need a unique identify like rowno() within your data-model and then in your table but you need such logic only for data-checks not for calculations.

- Marcus

View solution in original post

2 Replies
marcus_sommer

Then you need a unique identify like rowno() within your data-model and then in your table but you need such logic only for data-checks not for calculations.

- Marcus

veeranj
Creator II
Creator II

Hi Tushar,

Tab:

LOAD * INLINE [

   

    id, name

    1, a

    2, b

    3, c

    4, d

    5, e

    6, f

    7, g

    8, h

    9, i

    1,a

    2,b

    3,c

];

load *,rowno() as row Resident Tab;

drop table tab;

now load these id,name and row fields in straight table and use 1 as  expression and then go to "PRESENTATION TAB" of straight table  and then hide the ROW column and Expression column



Regards,

Anjee