Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

can i create a straight table in Sense with no dimensions?

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?

2 Replies
Highlighted
Champion III
Champion III

yes you can create but wmpty column will show.

in dimension give like this:   = ' 'dim.PNG

Highlighted
Specialist
Specialist

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