topic Re: Set Analysis using Variable in QlikView

Set Analysis using Variable

vanderson009 — Thu, 03 Jul 2014 06:03:44 GMT

Hi guys,

Please have look at set analysis that i am using

=Sum({<OrderWeek = {'$(vMaxWeek)-1'}>}Amount)

I want currentweek - 1 amount, but it won't work.

vMaxWeek is variable as Max(OrderWeek)

- Thanks and Regards,

Villyee

Thu, 03 Jul 2014 06:07:00 GMT

=Sum({<OrderWeek={$(vMaxWeek)-1}>} Amount)

Just remove the quotes.

jonathandienst — Thu, 03 Jul 2014 06:13:18 GMT

Assuming OrderWeek is a simple numerical field:

=Sum({<OrderWeek={$(=vMaxWeek-1)}>} Amount)

Should do the trick, but try using the function directly like this:

=Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)

HTH

Jonathan

Thu, 03 Jul 2014 06:14:43 GMT

try this

=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)

regards,

VishalWaghole — Thu, 03 Jul 2014 06:19:57 GMT

Hi Villyee,

Try

=Sum({<OrderWeek = {'$(=(vMaxWeek-1))'}>}Amount)

=Sum({<OrderWeek={$(=Max(OrderWeek)-1)}>} Amount)

-- Regards,

Vishal

vipin_mishra479 — Thu, 03 Jul 2014 06:22:56 GMT

HI villye,

create a variable of this (vMaxWeek)-1

like vPweek = (vMaxWeek)-1

and then use

Sum({<OrderWeek = {'$(vPweek )'}>}Amount)

vanderson009 — Thu, 03 Jul 2014 07:08:12 GMT

Thanks vishal, its working.............