Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In QlikView i can create a straight table without any dimensions. I do this to show the measures vertical instead of horizontal.
So the straight object will look like this:
dim1: no dimensions
exp1 : sum(Sales). Label : Sales
exp2 : sum(Margin), Label : Margin.
my straight table would look like this:
Sales 100
Margin 10
I could make it work in sense when i create a data island table with all the needed measure labels, and use the PICK function to calculate the needed value on the specific row. But this is kind of nasty and will become quite a big formula. Plus i can't use the MasterItems.
Anyone got a better solution?
yes you can create but wmpty column will show.
in dimension give like this: = ' '
But i can't want to see any dimension at all .. not even =''
plus your screenshot the measure is presented vertical. I need it horizontal
Count(OEL7_2) 502
Count(OEL8_1) 503
etc