Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
lionking15
Creator
Creator

HOW THE OUTPUT WILL DIFFER

HI

Please go through both the set and tell me the difference in output??

1-=sum({<Month={$(=month(max({<Year={$(=year(max(Date)))}>}Date)))},Year={$(=year(max(Date)))}>}[Sales Amount])

2-=sum({<Month={$(=month(max(Date)))},Year={$(=year(max(Date)))}>}[Sales Amount])

5 Replies
trdandamudi
Master II
Master II

I don't think you will see any difference...

Gysbert_Wassenaar

The output won't differ.


talk is cheap, supply exceeds demand
Anil_Babu_Samineni

Nothing there, If you use first expression the performance is ok but file size is bit increased. This scenario, I would recommend to use second one

sum({<Month={'=$(=month(max(Date)))'},Year={'=$(=year(max(Date)))'}>}[Sales Amount])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable

Nope there will be mo change in the output but the equation 1 is more detailed but not required. Equation2 is more than enough.

shree909
Partner - Specialist II
Partner - Specialist II

No change in the output.