Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Re: Create tables from Existing tables

Hi,

In QVD file you can upload anybody or all fields, without deleting them in the last line of the above code (see attached file).

In diagrams in UI, you can also use any saved fields. If the diagram does not depend on the user's choice, simply use Set Analysis expression, for example {1} in it.

Highlighted
Specialist II
Specialist II

Re: Create tables from Existing tables

Ok, its a bit cumbersome, but this does it (i think). It includes the current day in the 7 day total, you can adjust by changing what's included in the RangeSum.

daily_temp:

LOAD *

INLINE [

Date,                    Click_event,      Success_event,          Failure_event

'01-01-2017',              30,                          40,                              60

'01-02-2017',              10,                        10,                              70

'01-03-2017',              40,                        50,                              30

'01-04-2017',              60,                        20,                              20

'01-05-2017',              20,                        20,                              40

'01-06-2017',              60,                        50,                              30

'01-07-2017',              20,                        60,                              40

'01-08-2017',              60,                        20,                              20

'01-09-2017',              10,                        50,                              10

'01-10-2017',              60,                        30,                              10

'01-11-2017',              20,                        20,                              30

];

daily:

NoConcatenate

LOAD *,

RangeSum(Success_event,Peek(Success_event,-1),Peek(Success_event,-2),Peek(Success_event,-3),Peek(Success_event,-4),Peek(Success_event,-5),Peek(Success_event,-6)) as SevenDay_Success

Resident daily_temp;

drop table daily_temp;