topic Re: straight table in QlikView

straight table

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a straight table consisting of 15 dimensions and measures , I have taken one expression as =Field name.

Data will be like this:

Dimension1, Dimension2,Dimension3,Measure(=Field name)

a,x,1,100

b,y,2,100

c,z,3,200

a,x,2,100

in this above condition its works fine but if I omit Dimension3 it has to show like this.

Dimension1, Dimension2,Measure(=Field name)

a,x,100

b,y,100

c,z,,200

a,x,100

but it is showing

a,x,100

b,y,100

c,z,,200

Re: straight table

sunny_talwar — Wed, 14 Mar 2018 09:06:48 GMT

Check my response here

straight table

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 09:06:57 GMT

Rownr()

the qou see all

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 09:13:38 GMT

start:
load * inline
[ Dimension1,Dimension2,Dimension3,Measure
a,x,1,100
b,y,2,100
c,z,3,200
a,x,2,100
]

;
END:
load *,
Rowno() as visible
resident start;
drop table start ;

Re: straight table

Nagaraju_KCS — Wed, 14 Mar 2018 09:14:24 GMT

HI,

I think you have to use Sum(Measure)

Dimension1	Dimension2	=Sum(Measure)
Total		500
b	y	100
a	x	200
c	z	200

Table and Straight table shows only unique records.

If you take RowNo(), that will take sequence, 1,2 ,....and so on

use like

Load *, RowNo() as Key;

Load * inline [

Dimension1, Dimension2,Dimension3,Measure

a,x,1,100

b,y,2,100

c,z,3,200

a,x,2,100

]

Thanks..

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 09:14:42 GMT

greetings Gerry

Re: straight table

manoj217 — Wed, 14 Mar 2018 09:21:47 GMT

I don't want to add another dimension into the straight table

Re: straight table

Nagaraju_KCS — Wed, 14 Mar 2018 09:27:15 GMT

Take all dimensions and measure in Straight table

goto ---> presentation tab ---> select Dimension3 and Hide the column

Hope this works..

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 09:32:13 GMT

hide is not work in a straight table

you use the Diagramm box the you can use the Hide for the Dimension 3

gruß Gerold

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 09:34:33 GMT

hide is not work in a straight table

you use the Chart box the you can use the Hide for the Dimension 3

gruß Gerold

Re: straight table

Nagaraju_KCS — Wed, 14 Mar 2018 09:39:46 GMT

Roser, Hide columns should work in Straight table.

see below,

Re: straight table

gerry_hdm — Wed, 14 Mar 2018 10:02:46 GMT

Hello this a chart table

if understand you use a Table Box

sorry