topic Re: Cross table issue in QlikView

Cross table issue

Anonymous — Mon, 11 Sep 2017 08:31:15 GMT

I want to have a cross tabular view of my data. I tried using Pivot table as well, but the result was not satisfactory.
Please see pic above. In my report in need to show -(say by row 1).

in Sep'13 total 176 users get registered, out of which only 7 place orders in Sep'13, only 14 place orders in Oct'13, only 18 place orders in Nov'13, and so on.

Similarly for Oct'13, total number of new users getting registered is 308. Out of these 308 users only 11 is placing orders in Oct'13, 29 are placing orders in Nov'13, 30 are placing orders in Dec'13 and so on.

I have also search online sources, but could not get anything satisfactory. Can anyone help me on this.

Re: Cross table issue

Kushal_Chawda — Mon, 11 Sep 2017 11:53:35 GMT

Would you be able to share the sample data?

Re: Cross table issue

effinty2112 — Mon, 11 Sep 2017 13:18:46 GMT

Hi Saurav,

Try

Data:

CrossTable(Month, Orders, 2)

LOAD Date(FirstMonth,'MMM-YY') as FirstMonth,

[Reg Users],

[41671],

[41640],

[41609],

[41579],

[41548],

[41518]

FROM

[Cross table issue.xlsx] //your data was entered into this excel sheet

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Data1:

Load

FirstMonth,

[Reg Users],

Date(Num#(Month),'MMM-YY') as Month,

Num(Orders) as Orders

Resident Data;

DROP Table Data;

The this pivot table:

FirstMonth	Month	Feb-14	Jan-14	Dec-13	Nov-13	Oct-13	Sep-13
Sep-13		50	36	34	18	14	7
Oct-13		31	44	30	29	11	-
Nov-13		100	99	87	112	-	-
Dec-13		145	172	224	-	-	-
Jan-14		312	449	-	-	-	-
Feb-14		726	-	-	-	-	-

Cheers

Andrew