topic Re: How to display last 8 weeks data in QlikView

How to display last 8 weeks data

GOLATSO — Mon, 01 Mar 2021 08:24:20 GMT

I have weekly data in 2 sheets. The column names represent the week numbers and the year example 202001....for week 1.

I have similar column names in 2 sheets.

I need to show the data for both the sheets separately. Also i need to show only last 8 weeks data.

Tried CONCATENATE . I can see all the weeks data. I want only last 8 weeks of data by selection of the week number.

#newtoqv

Re: How to display last 8 weeks data

Taoufiq_Zarra — Mon, 01 Mar 2021 08:52:11 GMT

@GOLATSO can you share a sample data and the expected output ?

Re: How to display last 8 weeks data

GOLATSO — Mon, 01 Mar 2021 08:59:48 GMT

Expected output as below:

Re: How to display last 8 weeks data

Taoufiq_Zarra — Mon, 01 Mar 2021 09:13:29 GMT

can you elaborate you have other columns other than weeks and QP ? Unic ID Hrs Category Area KPI Unic ID Area Category QP

Re: How to display last 8 weeks data

GOLATSO — Mon, 01 Mar 2021 09:16:04 GMT

i need weekly data as per Area, Category and Hrs,

Re: How to display last 8 weeks data

edwin — Mon, 01 Mar 2021 13:39:42 GMT

Normally when multiple data sets are concatenated, a new field is created to identify the different data sets. this new field can then be used in your set analysis to refer to what data set is desired.
as to selecting last n weeks, i would personally use a week index. i would sort a distinct list of the week field in descending order and mark the most recent week as 0 and increase that as the week goes back. when a specific week is selected, i would save the selected week index in a variable and just add 7 (for an eight week spread) from that to get the lower bound. i can then use these two numbers in my set analysis to frame the desired period.
the lower/upper indices combined with the new field that identifies the data sets allows you to show last n weeks of what data set you want to display

Re: How to display last 8 weeks data

yassinemhadhbi — Mon, 01 Mar 2021 14:05:35 GMT

As i understand your requirement

I think the function Qualify * ; before the loading statement will do the job.