Pivot table with 2 dim

[omyahamburg]

Dear All

I have a table with fields

Department

YearMonth

Quantity

Turnover

My wish is to create a pivot table with dim1 Department and dim2 YearMonth

and an expression sum(Quantity) and sum(Turnover).

Is it possible to get the Quantity sum field and Turnover sum field under each other  like shown in below example ?

Department	YearMonth		Sum(value)
11	Jan 13	Quantity	528.965
		Turnover	1.567.013
11	Feb 13	Quantity	534.744
		Turnover	1.639.812
11	Mrz 13	Quantity	910.474
		Turnover	1.642.430

Thanks for your feedback.

Joerg

[luciancotea · Accepted solution]

Sure, just use your mouse to drag the expression title down next to the YearMonth dimension.

[er_mohit]

in pivot table put your mouse on expression side and drag it to dimension YearMonth

for doing this you ll see the blue line as in horizontal side and then you ll see th output like you want

[narender123]

Yes.Just drag 2nd expression and drop under 1st one expression.

Thanks.

[#5]

U can take  "CrossTable" Function in ETL ..

Crosstable (Measure1, Measure2,2)
Load
Department,

YearMonth ,

from... Source table;

[#6]

Hi Bika,

This is Amelia

Hi,

Could you help me it is very very urgent.

In the QMC in the system tab under Licences I have Qlikview server and Qlikview Publisher and Client access Licence tab (CALs) under general tab I have 10 named user CALs already 7 assigend and ALLOW LICENCE LEASE and ALLOW DYNAMIC CAL ASSIGNMENT both are in Enable state will it be like that by default or only ALLOW LICENCE LEASE should be checked? Please help me its very urgent

[#7]

Dear Amila 2000,

Pls check  below

Hope help u

[#8]

Hi Bika,

Already 7 assigned only 3 remain and all this is Qlikview Server not in QLikview Publisher if I check both when the next time any user opened the document the remaining three will also over right? I am confusing Could you please explain a bit more earlier this is not like this it's happend now only please help.

[#9]

Thanks Bika it's helped me and thanks very much for your prompt replies every time when I am posting.

[narender123]

If  3 new user are not part of your assigned license  then after opening document by new user , all 3 will capture the License.

Thanks.

Narender