Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
talita_verdes
Partner - Contributor III
Partner - Contributor III

Interval in bar chart

Good afternoon!


I have a problem and I can not solve.


I have the table below:


    

CD_SLAFIRST_DAYLAST_DAYINTERVAL
2196404/12/2014 10:0710/01/2017 09:07768
2329626/02/2015 10:4224/01/2017 08:39698
3157727/04/2016 18:4805/01/2017 14:41253
3236314/06/2016 15:0803/01/2017 11:34203
3249020/06/2016 13:0004/01/2017 15:50199
3289613/07/2016 11:0604/01/2017 15:49176
3334711/08/2016 13:5430/01/2017 10:35172
3343116/08/2016 15:5104/01/2017 15:49141
3586631/01/2017 14:5931/01/2017 15:021


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


8 Replies
sunny_talwar

May be just this

Dimension

None

Expression

Max(INTERVAL)

Min(INTERVAL)

greend21
Creator III
Creator III

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.

talita_verdes
Partner - Contributor III
Partner - Contributor III
Author

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

sunny_talwar

Try this

Ceil(

Interval(

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
talita_verdes
Partner - Contributor III
Partner - Contributor III
Author

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.

sunny_talwar

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

hjimenez25
Partner - Contributor II
Partner - Contributor II

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.