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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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