topic Re: bar chart sum last year total in QlikView

bar chart sum last year total

selcukcadir — Sun, 10 Nov 2013 14:20:31 GMT

hi all,

bar chart sum last year total

sum( {$<Year={"<=$(Year)-1"}>} value)

Dimensions : if(MonthYear >= '012013',MonthYear)

bar chart value :

012013 > 60

022013 > 60

032013 > 60

042013 > 60

052013 > 60

062013 > 60

072013 > 60

082013 > 60

092013 > 60

102013 > 60

112013 > 60

122013 > 60

Re: bar chart sum last year total

rustyfishbones — Sun, 10 Nov 2013 14:42:25 GMT

try

SUM({<Year = {'$(=max(Year)-1)'}>}value)

Regards

Re: bar chart sum last year total

rustyfishbones — Sun, 10 Nov 2013 14:56:09 GMT

or you could try

Re: bar chart sum last year total

selcukcadir — Sun, 10 Nov 2013 14:56:20 GMT

Hi Alan,

expression you sent ; SUM({<Year = {'$(=max(Year)-1)'}>}value)

should be ;

Re: bar chart sum last year total

selcukcadir — Sun, 10 Nov 2013 14:57:06 GMT

Hi Alan,

expression you sent ; SUM({<Year = {'$(=max(Year)-1)'}>}value)

should be ;

Re: bar chart sum last year total

rustyfishbones — Sun, 10 Nov 2013 15:01:16 GMT

so should it be

SUM({<Year = {'$(=max(Year))'}>}value)

which will give

Re: bar chart sum last year total

selcukcadir — Sun, 10 Nov 2013 15:10:36 GMT

should be ;

I want to be like

example : 012013 value >> 2012 vales total 60

012013 > 60

022013 > 60

032013 > 60

042013 > 60

052013 > 60

062013 > 60

072013 > 60

082013 > 60

092013 > 60

102013 > 60

112013 > 60

122013 > 60

Re: bar chart sum last year total

rustyfishbones — Sun, 10 Nov 2013 15:16:48 GMT

so add TOTAL, something like

Re: bar chart sum last year total

selcukcadir — Sun, 10 Nov 2013 16:20:07 GMT

Thanks Alan,

There is a more problem with,

Year to day total

how can ?

example : bar chart Dimensions >> montyear 08-2013

< 08-2013 + > 01-2013

value YTD total > 80+70+60+50+40+30+20+10 = 360

example : bar chart Dimensions >> montyear 07-2013

value YTD total > 70+60+50+40+30+20+10 = 280

Re: bar chart sum last year total

rustyfishbones — Sun, 10 Nov 2013 16:42:41 GMT

Hi,

See below, maybe this could get the result you need

Re: bar chart sum last year total

Yousef_Amarneh — Sun, 10 Nov 2013 23:43:44 GMT

do you want to show values greater than 60 only ? I couldn't understand your question !!

Re: bar chart sum last year total

selcukcadir — Mon, 11 Nov 2013 06:03:58 GMT

hi Yousef,

Dimensions >> montyear (YTD) total. I want to do.

Year to day total

how can ?

example : bar chart Dimensions >> montyear 08-2013

< 08-2013 + > 01-2013

value YTD total > 130+140+150+160+170+180+190+200 = 1320

example : bar chart Dimensions >> montyear 07-2013

value YTD total > 130+140+150+160+170+180+190 = 1120

Re: bar chart sum last year total

Yousef_Amarneh — Mon, 11 Nov 2013 16:10:21 GMT

see the attached file, I think it's working