topic Re: Issue in Set Analysis in QlikView

Issue in Set Analysis

Mon, 10 Nov 2014 09:39:16 GMT

Dear Team,

i want to compare Clientwise Sum(orders) - Sum(orders) of MIN Date.

for getting Orders of MIN Date i am using logic as below:

Created a Variable :

vMinOrderDate=min(ORDER_DATE)

then using below mention set analysis

SUM( {<ORDER_DATE={$(vMinOrderDate)}>} ORDERS)

Please let me know what wrong i am doing

PrashantSangle — Mon, 10 Nov 2014 09:41:19 GMT

Hi,

Try this,

with ""

SUM( {<ORDER_DATE={"$(vMinOrderDate)"}>} ORDERS)

Regards

alexandros17 — Mon, 10 Nov 2014 09:41:59 GMT

According to me, vMinOrderDate=min(ORDER_DATE) return the date in numerical represenatation so you are comparing a date to a number.

try with

vMinOrderDate=Date(min(ORDER_DATE))

let me know

Mon, 10 Nov 2014 09:44:33 GMT

I understand what mistake i was doing i was missing ' ' single quote Below mention is working now .. SUM( {} ORDERS)

Mon, 10 Nov 2014 09:46:31 GMT

Hi,

Keep '' wen you are using the variable in set analysis

SUM( {<ORDER_DATE={'$(vMinOrderDate)'}>} ORDERS) (or)

SUM( {<ORDER_DATE={"$(vMinOrderDate)"}>} ORDERS)

aveeeeeee7en — Mon, 10 Nov 2014 09:47:39 GMT

Hi Jitendra

Try this Expression:

SUM({<ORDER_DATE={'$(=MIN(ORDER_DATE))'}>}ORDERS)

Regards

Av7eN