Find First purchase month - Qlik Community

Rambhupal · ‎2019-06-25

I want to calculate first purchase month. Please refer the attachment. we need reruirement1,2,3

PrashantSangle · ‎2019-06-25

use firstsortedValue()

for detail see in help menu.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Aggre...

Regards,

Prashant Sangle

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 🙂

saminea_ANZ · ‎2019-06-25

PFA..

I've created the field Month_For just to change the format from your data set

MonthName(Date#(Month,'MMMYYYY')) as Month_For

Expression is used

MonthName(Min(TOTAL <[Corp Parent]> {<Value={"=Sum(Value)>0"}>} Month_For))