topic min gauge expression in QlikView

min gauge expression

Tue, 12 Apr 2011 12:53:21 GMT

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

min gauge expression

deepakk — Tue, 12 Apr 2011 13:06:45 GMT

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.

min gauge expression

Tue, 12 Apr 2011 14:03:13 GMT

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

min gauge expression

deepakk — Wed, 13 Apr 2011 05:42:54 GMT

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.