topic Re: sum/aggr no user selections time in QlikView

sum/aggr no user selections time

Sat, 10 Nov 2012 14:00:04 GMT

I have to create this columns "total value 2012", total value 2011", "total value jan 2012", "total value jan 2011" ignore user selections time

but according dimensions country,name. How?

LOAD * INLINE [

Name, Country, Value, Time

john, us, 10, 01-01-2012

kate, scotland, 120, 02-02-2012

kate, us, 1120, 03-03-2012

mac, us, 90, 01-01-2011

ddsds, uk, 200, 03-02-2011

pat, scotland, 100, 03-03-2011

pat, us, 10, 04-04-2012

];

Thanks

its_anandrjs — Sat, 10 Nov 2012 14:29:20 GMT

Hi,

Create month and year fields in the Load script some thing like this

Year(Replace(Time,'-','/')) as Year,

Month(Replace(Time,'-','/')) as Month

and

Create field some thing like in the load script also

sum(if(Year = 2011, Value)) as totalvalue2011,

sum(if(Year = 2012, Value)) as totalvalue2012,

sum(if(Year = 2012 and Month = 'Jan', Value)) as totalvaluejan2011

HTH

Regards,

Anand

its_anandrjs — Sat, 10 Nov 2012 14:53:33 GMT

Hi,

After creation of the Year and Month like

Year(Replace(Time,'-','/')) as Year,

Month(Replace(Time,'-','/')) as Month

If you want to use Set Analysis calculation this is also can be done like

For

totalvalue2011 = sum({<Year={'2011'}>} Value)

totalvalue2012 = sum({<Year={'2012'}>} Value)

totalvaluejan2011 = sum({<Month={'Jan'}, Year={'2011'}>} Value)

HTH

Regards,
Anand

Mon, 12 Nov 2012 08:54:53 GMT

I've tried this method but no ignore user selections time.

If the user select 2012 or 2012 or a month the values change.

I want the correct a total value always, perform any selection operator run.

Regards