# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Issue in Set Analysis

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

1 Solution

Accepted Solutions

Hi,

Try this,

with ""

like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
5 Replies

Hi,

Try this,

with ""

like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
MVP

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

Not applicable

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

Not applicable

Hi,

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

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

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

Specialist III

Hi Jitendra

Try this Expression:

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

Regards

Av7eN