topic Re: Less ten equal to not working in set in QlikView

Less ten equal to not working in set

Anonymous — Wed, 28 Aug 2013 11:39:35 GMT

Hi geniuses,

I am using this formula

sum({$<Year = {$(=only(Year))}, [Fiscal Week ID] = {"<=$(=max([Fiscal Week ID]))"}>} [Product Bookings Net])

Fiscal Week ID is Numeric

But instead of giving all the data set which has Fiscal week ID less then the Fiscal Week I am selecting it jus give me the result whic is similar too

Sum([Product Bookings Net])

Has to present to client tomo

pls help

Thanks,

Shashank

Re: Less ten equal to not working in set

rajeshvaswani77 — Wed, 28 Aug 2013 11:42:19 GMT

You must chnage double quotes to single quotes.

thanks,

Rajesh Vaswani

Re: Less ten equal to not working in set

Anonymous — Wed, 28 Aug 2013 11:50:45 GMT

If I am making selection on Fiscal Week Id it give me a correct answer but wen I make selection on Fiscal week it doesnot give me correct answer, though the Fiscal week Id And Fiscal week is linked

for exmple

if Fiscal week = wk1 Apr 2010

Fiscal week Id is=2010091

Re: Less ten equal to not working in set

CELAMBARASAN — Wed, 28 Aug 2013 12:11:16 GMT

It looks like on selecting year also it will display data.

try with this

sum({$<Year = {$(=Max(Year))}, [Fiscal Week ID] = {"<=$(=max([Fiscal Week ID]))"}>} [Product Bookings Net])