topic Chart,dimension in QlikView

Chart,dimension

QSense — Thu, 26 Apr 2012 08:22:59 GMT

Hi,

I have a problem. In chart graph,there is year dimension like 2009,2010.

For each year, I want to write avg the expresion value beyond the year dimension

how Can ı accomplish?

Best regards.

Chart,dimension

QSense — Thu, 26 Apr 2012 08:24:55 GMT

Chart,dimension

QSense — Thu, 26 Apr 2012 08:54:22 GMT

I want to get avg value of the Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM) expression and write to beyond for each year dimension

Chart,dimension

Thu, 26 Apr 2012 09:51:20 GMT

What do you mean by beyond year dimension??

can you explain it a little?

Ashutosh

Chart,dimension

QSense — Thu, 26 Apr 2012 09:59:50 GMT

when you look at chart you see year dimension 2009,2010,2011

I want tol write dimension like this 2009 (Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)) ,2010 (Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)) vs..

for example let assume 2009 year's avg value 1000 I want show year dimension like this 2009 (1000)

in chart

Chart,dimension

kaushiknsolanki — Thu, 26 Apr 2012 10:09:05 GMT

Hi,

You can try like this.

Add calculated dimension. Use expression for dimension as

=Year &'('& aggr(sum(Value1)/Sum(Value(2),Year) &')'

Regards,

Kaushik Solanki

Chart,dimension

Thu, 26 Apr 2012 10:15:29 GMT

Hi,

Then yes you can write it as under your dimension

=dual(Year &'('& aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year) &')', Year)

Just give it a try and let us know, if it works!!

Ashutosh

Chart,dimension

QSense — Thu, 26 Apr 2012 10:59:26 GMT

Unfotunately

it didnt work

Chart,dimension

Thu, 26 Apr 2012 11:09:38 GMT

Hi,

Try this also, while it is same but still just give it a try.!!!

Year &'('& aggr((Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)),Year) &')'

May be can you please share your app, or may be a sample app with your data. So, I can help you out on your app itself.!!!

Ashutosh

Chart,dimension

Thu, 26 Apr 2012 11:10:26 GMT

Also, you will need to replace Year with your year field.

Chart,dimension

QSense — Thu, 26 Apr 2012 11:52:52 GMT

In the abve you can see result

As you see paranthesis is seen but value is not,

I add formula ina text objectş it gets value (in blue area)

Re: Chart,dimension

Thu, 26 Apr 2012 12:21:31 GMT

Hi,

May be it is not able to calculate sum properly, Please check your expression.

Also, attached here is a sample app for you to see how it works.

If you still face issue then attach you app.

Ashutosh

Chart,dimension

QSense — Thu, 26 Apr 2012 13:07:13 GMT

Hi ,

It's size is big nearly 2 gb I can not attach

Chart,dimension

QSense — Thu, 26 Apr 2012 13:29:29 GMT

Dimension :

=Year(CalendarDate)&' ('&Aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year(CalendarDate))&')'

Expression :

Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)

Chart,dimension

QSense — Thu, 26 Apr 2012 14:10:29 GMT

Hi again,

My year field is CalendarDate

When I use it without year İn the formula ,It works but

CalendarDate format is dd.mm.yyyy So it works for each day but only ı want yearly avg

Chart,dimension

Thu, 26 Apr 2012 16:10:07 GMT

Okay not an issue, you can pick correct year.

Use

=Year(date#(CalendarDate,'DD.MM.YYYY'))&' ('&Aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year(date#(CalendarDate,'DD.MM.YYYY')))&')'

Just try it and let me know. It should work!!

Ashutosh

Chart,dimension

QSense — Fri, 27 Apr 2012 06:50:34 GMT

Hi Ashutosh

Unfortunately it didnt work

Chart,dimension

Fri, 27 Apr 2012 08:35:33 GMT

Hi,

Can you please put below expression into text object and select a date, Do you get year value??

Year( date#( CalendarDate,'DD.MM.YYYY' ) )

Ashutosh

Chart,dimension

Fri, 27 Apr 2012 08:37:30 GMT

Also, I see that in chart you are getting year value, how you are getting year there?

You can use the same field or formula and on basis of that can do aggregation.

Chart,dimension

QSense — Fri, 27 Apr 2012 08:51:52 GMT

Year( date#( CalendarDate,'DD.MM.YYYY' ) ) when ı put in into text object it gives error