Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suzel404
Creator
Creator

Lagging_Evol

Hi,

How can I calculate the lagging evolution: The evolution between H19 and H20 in % into crossTable.

H19vsH20 %

H20vsH21 %

H21vsH22 %

H22vsH23 %

H23vsH0 %

H0vsH1 %

H1vsH7 %

Thanks for your help.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be like this?

Script:

CrossTable(CalHour, HourSales)

LOAD Name,

     [19],

     [20],

     [21],

     [22],

     [23],

     [0],

     [1],

     [7],

     [10]

FROM

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 2))

));

Report:

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

May be like this?

Script:

CrossTable(CalHour, HourSales)

LOAD Name,

     [19],

     [20],

     [21],

     [22],

     [23],

     [0],

     [1],

     [7],

     [10]

FROM

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 2))

));

Report:

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)