straight table

[manoj217]

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

[sunny_talwar]

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?

[Anonymous]

as sunny is suggesting

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

qlik will automatically group dim with same

[jyothish8807]

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,

KC