Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
PrashantSangle

Hi,

Try this,

with ""

like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

5 Replies
PrashantSangle

Hi,

Try this,

with ""

like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
alexandros17
Partner - Champion III
Partner - Champion III

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
Author

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

Not applicable
Author

Hi,

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

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

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

aveeeeeee7en
Specialist III
Specialist III

Hi Jitendra

Try this Expression:

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

Regards

Av7eN