topic Re: Re: Hello Everyone, I am trying to make a chart. in QlikView

Hello Everyone, I am trying to make a chart.

Fri, 18 Oct 2013 12:49:07 GMT

I am Trying to make a chart whose table is like:

Year	Month	MoneyMeasure	Qty
2009	Jan	20,000	A
2009	Feb	21,000	B
2009	march	22,000	C\

this table is increasing for all months of 2009,

all months of 2010,

all months of 2011

So i need to make a chart for all qty for all months of year 2010.

So my chart should see like as:

Dimension containing months (Jan to Dec) of 2010 year,

and expression would sum(MoneyMeasure) regarding each qty....

Please help.

Thanks.

Re: Hello Everyone, I am trying to make a chart.

Anonymous — Fri, 18 Oct 2013 13:01:39 GMT

I am not sure if I understood ur requirement clearly.

Sum({<Year={'2010'}>}Moneymeasure)

Sum({<Year={'2010'}>}Qty)

Regards

Erika

Re: Hello Everyone, I am trying to make a chart.

nicander — Fri, 18 Oct 2013 13:06:15 GMT

try a pivot table. dimensions year and month.

Re: Hello Everyone, I am trying to make a chart.

Anonymous — Fri, 18 Oct 2013 13:58:29 GMT

Hi,

From what I understood from your post you have to make a chart and: in the dimensions tab put this calculated dimension =if(Year = 2010, Month) and in expression tab put this expression Sum(Aggr(Sum(MoneyMeasure),Qty)) with this label ='Total' & Sum(TOTAL MoneyMeasure) to calculate the total sum of MoneyMeasure.

Hope it helps.

BR,

Re: Hello Everyone, I am trying to make a chart.

Mon, 21 Oct 2013 05:05:43 GMT

Hii Alexandru,

thanks for reply,

I have a case in this chart that this chart will change its value according to my year selection, and that year is stored in a variable called vPriorYear as =Num(year)-1

That means need to calculate the selected years prior year value of qty.

I am writing this dimension like

=if(year=$(#vPriorYear),Month) this is showing error in calculated dimension.

Re: Hello Everyone, I am trying to make a chart.

er_mohit — Mon, 21 Oct 2013 05:36:10 GMT

use Pivot chart

Dim Year,Month

expression

sum({<Year={"$(=Year)"}>}Qty)

when you select any year then it 'll show you result

hope it helps

Re: Re: Hello Everyone, I am trying to make a chart.

Mon, 21 Oct 2013 06:03:17 GMT

Hi,

Don't use calculated dimension for your requirement,

You just use your Year and Months as your dimensions and use the below expression.

sum({<vYear = {'$(=Max(vYear)-1)'} >} vSales).

See the attachment for your reference.

Re: Hello Everyone, I am trying to make a chart.

Mon, 21 Oct 2013 06:28:34 GMT

Hi Nupur,

It is very simple to achieve such functionality. You just need to change you expression a little bit.

intead of using sum(MoneyNeasure)

Use this:

Sum({<Year={'2010'}>}MoneyMeasure)

This expression will apply the filter for 2010 and displays the values of MoneyMeasure related to year of 2010 only.

Re: Hello Everyone, I am trying to make a chart.

Mon, 21 Oct 2013 09:38:47 GMT

Hi Venugopal,

Thanks, your answer helped me a lot.

Re: Hello Everyone, I am trying to make a chart.

Mon, 21 Oct 2013 09:40:10 GMT

Thanks Hannan Tariq,

Able to make the chart .

Re: Hello Everyone, I am trying to make a chart.

Tue, 22 Oct 2013 05:54:14 GMT

Happy to help