topic Displaying last 5 days data in the bar chart in QlikView

Displaying last 5 days data in the bar chart

qlikcheepirishe — Wed, 25 Nov 2020 16:16:04 GMT

As attached I have data set

my basic requirement is tooo get last 5 days data for example

wanted to view data for 29/11/2017 500

30/11/2017 500

01/12/2017 200

02/12/2017 200

03/12/2017 300

Total 1700/-

In bar chart last 5 days

Re: Displaying last 5 days data in the bar chart

Anil_Babu_Samineni — Mon, 11 Dec 2017 06:33:39 GMT

In image, There is 4 and 5th dates also should be placed right? May be Rank - chart function ‒ QlikView

Re: Displaying last 5 days data in the bar chart

qlikcheepirishe — Mon, 11 Dec 2017 06:56:05 GMT

on 29th the value is 500 and on 30th also 500 total for november month will be 1000

from 01/12/2017 it is 200 and 02/12/2017 so it should aggregate 400 in date 02/12/2017

Re: Displaying last 5 days data in the bar chart

Anil_Babu_Samineni — Mon, 11 Dec 2017 06:59:28 GMT

When you use Date field as dimension and you want to be Month aggregated, should be this?

Sum(TOTAL <Month> VALUE)

Sum(Aggr(Sum(VALUE), Month))

Re: Displaying last 5 days data in the bar chart

devarasu07 — Mon, 11 Dec 2017 07:07:55 GMT

Hi,

Try to use date range in set analysis expression

SUM({<NEWDATE = {">$(=Date(Max(NEWDATE)-5))<=$(=Date(Max(NEWDATE)))"}>}VALUE)

Fact:

LOAD Date(Date) as NEWDATE,VALUE INLINE [

Date, VALUE

29/11/2017, 500

30/11/2017, 500

1/12/2017, 200

2/12/2017, 200

3/12/2017, 300

4/12/2017, 400

5/12/2017, 500

];

Re: Displaying last 5 days data in the bar chart

qlikcheepirishe — Mon, 11 Dec 2017 07:30:45 GMT

THE ABOVE CONDITION IS WORKING FINE ONE MORE REQUIREMENT

I WANT TO AGGREGATE THE TOTAL WITHOUT SELECTION

Re: Displaying last 5 days data in the bar chart

Anil_Babu_Samineni — Mon, 11 Dec 2017 07:34:25 GMT

Does it mean these?

Sum({1} TOTAL <Month> VALUE)

Sum({1} Aggr(Sum({1} VALUE), Month))

Re: Displaying last 5 days data in the bar chart

qlikcheepirishe — Mon, 11 Dec 2017 07:46:12 GMT

THE SAME CONCEPT CAN BE DONE AT BACK END devarasu07‌

Re: Displaying last 5 days data in the bar chart

devarasu07 — Mon, 11 Dec 2017 08:26:10 GMT

Hi,

Yes, try like below,

Temp:
LOAD * INLINE [
    NEWDATE, VALUE
    29/11/2017, 500
    30/11/2017, 500
    1/12/2017, 200
    2/12/2017, 200
    3/12/2017, 300
    4/12/2017, 400
    5/12/2017, 500
];
vMax:
load max(Date(NEWDATE)) as MaxDate Resident Temp;
LET vMax = floor(Peek('MaxDate'));
LET v5DaysAgo = floor(Peek('MaxDate'))-5;
Fact:
load Date(floor(NEWDATE)) as Date1, VALUE Resident Temp where date(NEWDATE)>date('$(v5DaysAgo)') and date(NEWDATE)<=date('$(vMax)');
Drop tables vMax, Temp;

Re: Displaying last 5 days data in the bar chart

qlikcheepirishe — Mon, 11 Dec 2017 09:51:03 GMT

I WANTED TO INCLUDE 29TH 30TH 1 2 3 AND DISPLAY