topic Re: Grouped dimensions in QlikView

Grouped dimensions

Wed, 12 Jun 2013 12:36:45 GMT

Hi All,

If I want to have last 7 days, 7-21days(for data entered in previous two weeks), >21days(data entered before 21 days) in the dimension axis for diplaying count of data, How can I get it?

Thanks

Re: Grouped dimensions

Wed, 12 Jun 2013 12:42:32 GMT

you could use a calculated dimension :

if(DATE > today()-7, '7 days',

if(DATE > today()-21, '7-21 days', '>21 days' ))

Re: Grouped dimensions

Fri, 05 Jul 2013 11:58:07 GMT

Thanks!