Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manoj217
Contributor II

straight table

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

3 Replies

Re: straight table

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?

delroekid
Contributor

Re: straight table

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
Honored Contributor II

Re: straight table

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

Best Regards,
KC
Community Browser