Table with just measures as columns and rows?

[Anonymous]

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

[Anonymous]

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]

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]

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]

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 · Accepted solution]

I managed to do it like this.

Dimension

[PRODUCT FAMILY]

Measures

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