topic Re: numeric compare - in QlikView

numeric compare -

Wed, 29 Aug 2012 19:37:52 GMT

Took over for somebody and am very new at this. The person left the company.

I seem to be fine when comparing alpha but am having trouble when it's a numeric column AND the issue might also be the GreaterThan sign.

I need to also include only items where the quantity is > 1000.

sum({<DNOY = {"<=$(=DayNumberOfYear(Today()))" },Year= {"$(=Max(Year))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Quantity Ordered] > 1000 , [Order Generation Number]= {0}, [Order Type] = {'O'}, [Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped]) /

sum({<DNOY = {"<=$(=DayNumberOfYear(Today()))" },Year= {"$(=Max(Year))"} ,[Order Generation Number]= {0},[Drop Ship Code (Y or N)]= {'N'},[Order Type] = {'O'},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered])

Re: numeric compare -

Anonymous — Wed, 29 Aug 2012 19:58:23 GMT

I think this will work:

[Quantity Ordered]={">1000"}

Regards,

Michael

Re: numeric compare -

Mon, 10 Sep 2012 19:26:04 GMT

The bold sytax doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.

( sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {'03'}, [Quantity Ordered]={"<100000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped]) +

sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Shipped])) /

sum({<[Dayend Date] = {">=$(=Max([Dayend Date]))"} ,[Drop Ship Code (Y or N)]= {'N'}, [Order Generation Number]= {0}, [Order Type] = {'O'}, [Item Class]= {"<>03"}, [Quantity Ordered]={"<1000"},[Update Demand] = {'Y'},[Line Item Type] = {'I'}>} [Quantity Ordered]))

Re: numeric compare -

Mon, 10 Sep 2012 19:26:18 GMT

Re: numeric compare -

Mon, 10 Sep 2012 19:27:08 GMT

The alpha comparison of 03 doesn't seem to be working. I need to do one thing if the Item Class = 03 (which is an alpha field) and another if it doesn't equal 03. Sorry for the elementary questions but I've still not been to training and can't find any examples of how expression syntax works.

[Item Class]= {"<>03}

Re: numeric compare -

Mon, 10 Sep 2012 19:28:21 GMT

[Item Class]= {"<>03"}

Re: numeric compare -

MayilVahanan — Mon, 10 Sep 2012 20:36:17 GMT

[Item Class] -= {"03"}

This exclude the 03 value in it..

Hope it helps