Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
as sunny is suggesting
the best way is to include all dim and hide the 3rd one.
qlik will automatically group dim with same
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