topic Re: Plot daily max for specific values in field in QlikView

Plot daily max for specific values in field

Anonymous — Mon, 17 Apr 2017 22:49:15 GMT

I am having some difficulty building a line chart of daily max tablespace usage for specific databases. What I would like in my dashboard is a stack of line charts that each represent one database and it's tablespaces max memory usage from each day. There are actually many databases but they all have the same tablespace names associated with them. So each line chart should have 3 lines, one for each table each with one data point per day. And this data comes in every hour. My original idea was based on using a master calendar, which I set up and associated with the timestamps. But I couldn't wrap my head around the logic. Here is a representation of the data:

DB Name	Timestamp	Table	Mem. Usage
AAA	4/15/17 10:00	Table 1	10
AAA	4/15/17 10:00	Table 2	15
AAA	4/15/17 10:00	Table 3	5
BBB	4/15/17 10:00	Table 1	20
BBB	4/15/17 10:00	Table 2	25
BBB	4/15/17 10:00	Table 3	30
...	...	...	...
AAA	4/15/17 12:00	Table 1	15
AAA	4/15/17 12:00	Table 2	20
AAA	4/15/17 12:00	Table 3	10
BBB	4/15/17 12:00	Table 1	15
BBB	4/15/17 12:00	Table 2	25
BBB	4/15/17 12:00	Table 3	35
...	...	...	...
AAA	4/16/17 10:00	Table 1	15
AAA	4/16/17 10:00	Table 2	20
AAA	4/16/17 10:00	Table 3	10
...	...	...	...

Thanks in advance!

Re: Plot daily max for specific values in field

hector_munoz — Tue, 18 Apr 2017 05:55:34 GMT

Hi Sam,

Could you, based on the shared example, create a simple table with the final desired result? So, we could (at least me) understand what you exactly need... ;-).

Regards,
H

Re: Plot daily max for specific values in field

Anonymous — Tue, 18 Apr 2017 16:21:57 GMT

Sure,

Based on my example table I want 2 line charts each with 3 plot lines, one for each table. The value points for each plot line should only be the daily max, instead of the hourly information I am currently getting.

Chart 1:

AAA | 4/15/17 12:00 | Table 1 | 15

AAA | 4/15/17 12:00 | Table 2 | 20

AAA | 4/15/17 12:00 | Table 3 | 10

AAA | 4/16/17 10:00 | Table 1 | 15

AAA | 4/16/17 10:00 | Table 2 | 20

AAA | 4/16/17 10:00 | Table 3 | 10

Chart 2:

BBB | 4/15/17 10:00 | Table 1 | 20

BBB | 4/15/17 12:00 | Table 2 | 25

BBB | 4/15/17 12:00 | Table 3 | 35

I apologize I didn't include enough example data the get more than one plot value for each of BBB's table's. I hope that is enough info to make sense of what I am talking about.

Re: Plot daily max for specific values in field

hector_munoz — Tue, 18 Apr 2017 19:00:31 GMT

OK Sam,

So, for chart 1:

First dimension (calculated): Date(Timestamp#([Timestamp], 'MM/DD/YYYY hh:mm'), 'MM/DD/YYYY')
Second dimension: Table
Expression: Max({<[DB Name]={AAA}>} [Mem. Usage])

, and for chart 2:

First dimension (calculated): Date(Timestamp#([Timestamp], 'MM/DD/YYYY hh:mm'), 'MM/DD/YYYY')
Second dimension: Table
Expression: Max({<[DB Name]={BBB}>} [Mem. Usage])

I would recommend you to create a date field based on Timestamp field in script...

Hope it serves!

Regards,

Re: Plot daily max for specific values in field

Anonymous — Tue, 18 Apr 2017 21:11:37 GMT

Brilliant!

It was all in the bracket/brace usage. I was close but I just don't have a strong enough understanding of where and when I should use the many different bracket/brace options.

Thanks for all your help!

Sam

Re: Plot daily max for specific values in field

hector_munoz — Tue, 18 Apr 2017 21:20:04 GMT

Thanks Sam! Glad to help you!