topic Re: bar chart issue in QlikView

bar chart issue

Thu, 04 Feb 2016 13:39:17 GMT

Hi Experts,

I have to show the data in single bar with indicator like guage chart, if count(sales)>50 green color remaining is gray color.

i'm attaching the sample document please give me your suggestion to modify.

Regards,

Mike

vikasmahajan — Fri, 05 Feb 2016 07:14:31 GMT

Qvw is opening please create and attach again

its_anandrjs — Fri, 05 Feb 2016 07:19:04 GMT

Please attached the snap shot for the requirement.

Regards

Anand

HirisH_V7 — Fri, 05 Feb 2016 08:27:03 GMT

Hi,

is this,

using value list,

Create a dimension: =ValueList('Sales')

Expressions: =if(ValueList('Sales'),'Sales',Sum(Sales))

=if(ValueList('Sales'),'Sales',Sum(Sales)/2)

HTH,

PFA,

Hirish