Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

Weekly data for max dates

Hi guyz,

I have data with

DateTypeBalance
1/9/2016A

100

2/9/2016A42
5/9/2016A21
6/9/2016A213
9/9/2016A324
10/9/2016A4323
11/9/2016B213
7/9/2016A3423
8/9/2016A324
12/9/2016A65
13/9/2016A4544
16/9/2016A343
16/9/2016B23421
16/9/2016A341
16/9/2016A

3543

I need Weekly bar chart. Every Friday balance amount in the account.

need bar chart with  Week 1-2 -> 42

Week 5-9 -> 324

Week 12-16 -> 6568

in bar chart together

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Table:

LOAD Date,

  Week(Weekstart(Date,0,-2)) as Week,

  WeekDay(Date) as WeekDay,

  Day(Date) as Day,

    Type,

    Balance

FROM

[https://community.qlik.com/thread/234094]

(html, codepage is 1252, embedded labels, table is @1) where Len(Trim(Date))>0;

Join

Load

  Week,

  Max(Day) as MaxWeekDay,

  Min(Day) as MinWeekDay

Resident Temp Group By Week;

Untitled.png

View solution in original post

3 Replies
tresesco
MVP
MVP

How is Week 12-16 -> 6568 coming?

tresesco
MVP
MVP

Try like:

Table:

LOAD Date,

  Week(Weekstart(Date,0,-2)) as Week,

  WeekDay(Date) as WeekDay,

  Day(Date) as Day,

    Type,

    Balance

FROM

[https://community.qlik.com/thread/234094]

(html, codepage is 1252, embedded labels, table is @1) where Len(Trim(Date))>0;

Join

Load

  Week,

  Max(Day) as MaxWeekDay,

  Min(Day) as MinWeekDay

Resident Temp Group By Week;

Untitled.png

saumyashah90
Specialist
Specialist
Author

sorry my mistake...its sum of all balance