topic Re: Guage Chart in QlikView

Guage Chart

Wed, 17 Oct 2012 03:56:09 GMT

my excel design is that

I want to use ONE chart to show the highest money and use another chart to show the second-high money.

At the same time, I can show the "Company" as the title.

Thanks.

Wed, 17 Oct 2012 05:14:00 GMT

Hi,

Do you need the highest Money per Date and per Company?

Regards,

Janzen

Wed, 17 Oct 2012 06:14:11 GMT

Hi Grace,

Please Find this attachment.

Hope this helps You.

Max-1= FieldValue('salary',FieldIndex('salary',max(salary))-1)

Max=Max(salary)

Regards,

Kabilan K.

Wed, 17 Oct 2012 07:24:24 GMT

Hi,

Hope this one helps,

Regards,

Janzen

Wed, 17 Oct 2012 10:24:17 GMT

Thanks all of you.

But it still cannot show "Company" above the chart.

That's mean if Company A has the largest money on that day, I want the chart show the money and the company name.

Thanks again!

Thu, 18 Oct 2012 04:37:48 GMT

Hi,

U can write a expression in Title text box like below.

='Company'&FieldValue('Company',FieldIndex('Money',max(Money)))&'__'&FieldValue('Money',FieldIndex('Money',max(Money)))

Regards,

Kabilan K.