topic Re: Pivot table with 2 dim in QlikView

Pivot table with 2 dim

omyahamburg — Thu, 11 Jul 2013 06:16:51 GMT

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
11	Jan 13	Turnover	1.567.013
11	Feb 13	Quantity	534.744
11	Feb 13	Turnover	1.639.812
11	Mrz 13	Quantity	910.474
11	Mrz 13	Turnover	1.642.430

Thanks for your feedback.

Joerg

Re: Pivot table with 2 dim

luciancotea — Thu, 11 Jul 2013 06:22:55 GMT

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

Re: Pivot table with 2 dim

er_mohit — Thu, 11 Jul 2013 06:35:24 GMT

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

Re: Pivot table with 2 dim

narender123 — Thu, 11 Jul 2013 07:05:34 GMT

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

Thanks.

Re: Pivot table with 2 dim

Thu, 11 Jul 2013 07:33:41 GMT

U can take "CrossTable" Function in ETL ..

Crosstable (Measure1, Measure2,2)
Load
Department,

YearMonth ,

from... Source table;

Re: Pivot table with 2 dim

Thu, 11 Jul 2013 07:40:54 GMT

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

Re: Pivot table with 2 dim

Thu, 11 Jul 2013 07:48:21 GMT

Dear Amila 2000,

Pls check below

Hope help u

Re: Pivot table with 2 dim

Thu, 11 Jul 2013 07:51:30 GMT

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.

Re: Pivot table with 2 dim

Thu, 11 Jul 2013 08:29:27 GMT

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

Re: Pivot table with 2 dim

narender123 — Thu, 11 Jul 2013 09:03:23 GMT

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