Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead 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.

View solution in original post

5 Replies

Hi,

Try this,

with ""

like

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

Regards

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

View solution in original post

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
Specialist III

Hi Jitendra

Try this Expression:

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

Regards

Av7eN