Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Rambhupal
New Contributor

Find First purchase month

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

2 Replies

Re: Find First purchase month

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.
saminea_ANZ
Contributor

Re: Find First purchase month

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))