topic Re: Full Table in Straight Chart in QlikView

Full Table in Straight Chart

Wed, 13 Aug 2014 13:54:52 GMT

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.

Re: Full Table in Straight Chart

marcus_sommer — Wed, 13 Aug 2014 14:03:03 GMT

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

Re: Full Table in Straight Chart

veeranj — Wed, 13 Aug 2014 14:08:05 GMT

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