topic Interval in bar chart in QlikView

Interval in bar chart

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

Good afternoon!

I have a problem and I can not solve.

I have the table below:

CD_SLA	FIRST_DAY	LAST_DAY	INTERVAL
21964	04/12/2014 10:07	10/01/2017 09:07	768
23296	26/02/2015 10:42	24/01/2017 08:39	698
31577	27/04/2016 18:48	05/01/2017 14:41	253
32363	14/06/2016 15:08	03/01/2017 11:34	203
32490	20/06/2016 13:00	04/01/2017 15:50	199
32896	13/07/2016 11:06	04/01/2017 15:49	176
33347	11/08/2016 13:54	30/01/2017 10:35	172
33431	16/08/2016 15:51	04/01/2017 15:49	141
35866	31/01/2017 14:59	31/01/2017 15:02	1

I need to display in a bar chart the maximum value of interval column and the minimum value.

The result would be:

Max: 768

Min: 1

How can i do it?

Thanks

Re: Interval in bar chart

sunny_talwar — Thu, 25 Jan 2018 18:00:04 GMT

May be just this

Dimension

None

Expression

Max(INTERVAL)

Min(INTERVAL)

Re: Interval in bar chart

greend21 — Thu, 25 Jan 2018 18:52:29 GMT

You could try setting the Dimension Limits to show only smallest 1 value. Then select show others and maybe try max(INTERVAL). I never used the Show Others option but it seems like it should work.

Re: Interval in bar chart

talita_verdes — Thu, 25 Jan 2018 20:09:36 GMT

My problem is that the interval column is calculated with the following formula:

Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

I already tried min, max, rangemin but it did not solve

Re: Interval in bar chart

sunny_talwar — Thu, 25 Jan 2018 20:11:23 GMT

Try this

Ceil(

Interval(

Max(Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA)),'D'))

Re: Interval in bar chart

kaushiknsolanki — Thu, 25 Jan 2018 20:12:26 GMT

Not sure but you can try this.

Max(Aggr(Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D')), CD_SLA))

Min(Aggr(Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D')), CD_SLA))

Regards,

Kaushik Solanki

Re: Interval in bar chart

talita_verdes — Thu, 25 Jan 2018 20:34:44 GMT

Sunny and Kaushik

I tried these expressions before, but It didn't work.

My bar char has monthName dimension from master calendar.

I tried use on aggregation the field MonthName, but it didn't work too.

Re: Interval in bar chart

sunny_talwar — Thu, 25 Jan 2018 20:35:37 GMT

Would you be able to share a sample to show what you have?

Re: Interval in bar chart

hjimenez25 — Thu, 25 Jan 2018 20:39:17 GMT

Hi,

Maybe you can try this:

Expression:

Max( TOTAL Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

)

Min( TOTAL Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

)

I hope this help you.