Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakwinder
Contributor III

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
lakwinder
Contributor III

Re: Table with just measures as columns and rows?

I managed to do it like this.

Dimension

[PRODUCT FAMILY]

Measures

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

5 Replies
lakwinder
Contributor III

Re: Table with just measures as columns and rows?

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 .

reddys310
Honored Contributor II

Re: Table with just measures as columns and rows?

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.

lakwinder
Contributor III

Re: Table with just measures as columns and rows?

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

reddys310
Honored Contributor II

Re: Table with just measures as columns and rows?

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.

lakwinder
Contributor III

Re: Table with just measures as columns and rows?

I managed to do it like this.

Dimension

[PRODUCT FAMILY]

Measures

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

Community Browser