topic Re: Cross Table with looping in QlikView

Cross Table with looping

Wed, 25 Nov 2020 16:16:04 GMT

hiii i m stuck in issue whr i want 2 cross table nd then concatenate. i m attaching the dummy data along with output

Re: Cross Table with looping

Mon, 20 Jun 2016 02:18:45 GMT

Hi Amit,

You can try the script below. For the Month, you might need to rename to Month Year if you need to link it to a calendar. Currently i just show as what they are

Retails_Tmp:

LOAD [All Models Retails] As [SR No],

F2 As [Region],

F3 As [Dlr Code],

F4 As City,

'Retail' As Type,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

July

FROM

(ooxml, embedded labels, header is 1 lines, table is Retails, filters(

Remove(Row, Pos(Top, 2))

))

WHERE Len([All Models Retails])>0;

Sales:

CrossTable(Mth, Val,5)

LOAD *

Resident Retails_Tmp;

DROP TABLE Retails_Tmp;

WS_Tmp:

LOAD [All Models Wholesale] As [SR No],

F2 As [Region],

F3 As [Dlr Code],

F4 As City,

'Wholesale' As Type,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

July

FROM

(ooxml, embedded labels, header is 1 lines, table is WS, filters(

Remove(Row, Pos(Top, 2))

));

//this will concatenate with the first Sales crosstable

CrossTable(Mth, Val,5)

LOAD *

Resident WS_Tmp;

DROP TABLE WS_Tmp;

Re: Cross Table with looping

settu_periasamy — Mon, 20 Jun 2016 03:19:46 GMT

May be check the Attachment.

Re: Cross Table with looping

Mon, 20 Jun 2016 04:26:52 GMT

which attachment

Re: Cross Table with looping

settu_periasamy — Mon, 20 Jun 2016 06:41:54 GMT

I think you are looking via inbox. open the separte window.. or click here..

Cross Table with looping

Re: Cross Table with looping

Mon, 20 Jun 2016 08:24:19 GMT

thnks

Re: Cross Table with looping

Mon, 20 Jun 2016 08:30:51 GMT

could you provide me qvw of the code and also tell me how you are using this" Remove(Row, Pos(Top, 2))"

Re: Cross Table with looping

Mon, 20 Jun 2016 10:00:06 GMT

You can just follow the File Wizard steps. Please see attached file for the step i did