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: 
Not applicable

min gauge expression

Hi Guys,

Went through some verfied posts and none actually have the same problem I got 🙂 Ok, so I have a gauge chart that I want to sit min and max values for.

I've used set-analysis in the expression and this is what it reads sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours)

I want my min value to be the min sum of the above constraints/criteria in my expression. So i wrote

Min(sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours) but thats not working. Any ideas on where I am going wrong gentlemen and ladies

Thanks,

Byron

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

hi Bryon,

Try this out .

Min( aggr(sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours), FieldName))

Fieldname would be the dimension based on which you want to aggregate.

View solution in original post

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi Bryon,

Try this out .

Min( aggr(sum({1<CostCode={'Normal Time'}, Week={'2011/03/06}>}Hours), FieldName))

Fieldname would be the dimension based on which you want to aggregate.

Not applicable
Author

Thank you! If you read this reply thought I mght hijack my own trhead to ask a really simple question 🙂 With regards to text boxes, can with choose the direction of the text. if so where do I need to do if I want the text to be say vertically down?

Thanks

Byron

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

In General tab of Text box select verticla scroll bar. Now reduce the width of the text box till ur text moves in vertical direction.

I think u r looking for same stuff.