topic Re: Need Bar Graph help in QlikView

Need Bar Graph help

ananyaghosh — Fri, 08 May 2015 13:16:57 GMT

Hi,

I need to create a bar graph and have to use year as dimension, but need to largest two year in dimension and have to use summation of Income and Expense as expression.

Please suggest what to do in dimension and expression?

thanks,

Sandip

Re: Need Bar Graph help

Gysbert_Wassenaar — Fri, 08 May 2015 13:56:52 GMT

See attached qvw.

Re: Need Bar Graph help

Anonymous — Fri, 08 May 2015 14:39:26 GMT

Like this?

Re: Need Bar Graph help

buzzy996 — Fri, 08 May 2015 15:28:02 GMT

try tis,

set ur dimenions as year in dimenion table,

set ur expressions,sum(exp) ,sum(income) on expression tab,ur 2 expressions,

on dimenion limits tab just set largest as 2,uncheck other from bottom if u don't want.

Re: Need Bar Graph help

ananyaghosh — Mon, 11 May 2015 05:34:21 GMT

Hi,

It is straight table. But I want to show a bar graph. So if i am trying to create a bar graph no data is showing. Please help me to make a bar graph.

Re: Need Bar Graph help

ananyaghosh — Mon, 11 May 2015 05:34:48 GMT

I did not see the largest two values in your graph. The largest two values of year should be 2015, 2014, but if I am restrict the values of two in limit dimension tab, it shows the wrong value.

Re: Need Bar Graph help

anbu1984 — Mon, 11 May 2015 06:42:12 GMT

Check this app. Largest two years are 2014 and 2012

Re: Need Bar Graph help

ananyaghosh — Mon, 11 May 2015 07:12:03 GMT

In my Attached excel sheet 2015 and 2014 are the largest two years. But it is now showing your app. So what to do now. Please suggest.

Re: Need Bar Graph help

anbu1984 — Mon, 11 May 2015 08:38:45 GMT

Check the Straight table in my app. I am getting the same values for 2015 when I sum them in your excel.