Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table with just measures as columns and rows?

Hi Guys

I'm trying to do Dim as Sales (down) and Measure as Month (across) but it's seem to not working, it's adding both as across

when i do MONTH='201509', I'm getting two rows 0 and -1 in the measure, i don't want any rows apart from my Sales.

I want something like this: Just realised it has to be all measures no dimensions.

               measure (Sep 2015)    measure(Oct 2015)

(measure) Sales1        10                 20

(measure) Sales 2       23                 25

So a table with just measures, is that possible.

Thanks

Lak

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I managed to do it like this.

Dimension

[PRODUCT FAMILY]

Measures

ceil(sum({<[SALES MONTH]={"201509"},[PRODUCT FAMILY]={"Sales1","Sales2"}>}Value_PQ),5)/1000

View solution in original post

5 Replies
Anonymous
Not applicable
Author

It will work as a Pivot table with sales months going down and each sales measure going across, but i need, sales measures going down and sales month going across .

reddy-s
Master II
Master II

Hi Lak,

I am afraid that its not possible with either a pivot table or a Straight table. But it would be a very easy extension to build if its a mandatory requirement.

Anonymous
Not applicable
Author

I can't remember if it was possible in QV, CROSSTABLE PERHAPS?

In pivot table, the months run down nicely, can i not make them run across?

Where can i start to do something like this in extensions?  any material or links?

Thanks

lak

reddy-s
Master II
Master II

Hi Lak,

You can  develop extensions from the dev-hub: http://localhost:4848/dev-hub or http://localhost:4848/workbench

Check these links out for more information:

Qlik Branch

https://help.qlik.com/sense/1.1/en-us/developer/

Let me know if you need any further help.

Cheers,

Sangram.

Anonymous
Not applicable
Author

I managed to do it like this.

Dimension

[PRODUCT FAMILY]

Measures

ceil(sum({<[SALES MONTH]={"201509"},[PRODUCT FAMILY]={"Sales1","Sales2"}>}Value_PQ),5)/1000