topic Re: Expression help???? in QlikView

Expression help????

amit_saini — Thu, 03 Jul 2014 12:26:04 GMT

Hi Folks ,

I'm having expression as below: (here Test and vDeliverced are two varibles)

sum({<Year ={$(=Year(AddMonths(now(),-1)))}, AccumType = {'YTD'}, [Major Defect Group]=, Month = {"<=$(=num(month(AddMonths(now(),-1))))"}> }$(Test)) / sum({<Year ={$(=Year(AddMonths(now(),-1)))}, AccumType = {'YTD'}, [Major Defect Group]=, Month = {"<=$(=num(month(AddMonths(now(),-1))))"}>}$(vDelivered))*1000

This expression given be bars with same numbers, looks like something wrong.

Kindly help.

Thanks,

Re: Expression help????

MK_QSL — Thu, 03 Jul 2014 12:41:49 GMT

What is your Month Field looks like... is it in Number format or Text...

Re: Expression help????

avinashelite — Thu, 03 Jul 2014 12:48:06 GMT

Hi Amit,

Can you kindly post your app here, so that we can analyse the problem.

Regards,

@vi

Re: Expression help????

amit_saini — Fri, 04 Jul 2014 10:38:28 GMT

Manish,

It having values like Jan Feb March....

Thanks,