topic 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:35 GMT

That is because a table can only show a unique combination of rows based on your dimension... because a and x repeat... it only show it once... if you are using this in a straight table, why don't you add dimension 3 as a dimension and then hide it from the presentation tab?

Re: straight table

Anonymous — Fri, 16 Mar 2018 00:45:52 GMT

as sunny is suggesting

the best way is to include all dim and hide the 3rd one.

qlik will automatically group dim with same

Re: straight table

jyothish8807 — Fri, 16 Mar 2018 04:47:29 GMT

Hi Manoj,

You can also add a field Rowno() from the script and use it to show all the values. You can hide that field as suggested by Sunny,

Load

rowno() as Sino,

Dim1,

Dim2,

Dim3

from <>

In the straight chart you can use any dimension with Sino field and hide Sino field from presentation tab.

Hope it helps.

Br,