Group by on specific field value

[Aditya_Chitale]

Hi All,

I have loaded table as below

Order No	Batch No	Customer Name	Date
1	99308	ABC	01-04-2022
2	99292	ABC	05-31-2022
3	99310	XYZ	06-19-2022
4	99018	XYZ	06-09-2022
4	99313	PQR	04-02-2022
3	99310	UVW	01-01-2022

As seen there are multiple dates for some customer names. I want only the minimum date for Customer ABC (Here 01-04-2022). Tried using Group by, but didn't work since I have calculated measures in my table.

Any help would be appreciated

Regards,

Aditya

[Digvijay_Singh]

Utilize firstsortedvalue to achieve this - 

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Basic...

[anat]

have u tried like 

load customername,min(Date) resident test group by customername;

[Aditya_Chitale]

@Digvijay_Singh 

I want min(Date) only for one value of Customer ie. ABC

Regards,

Aditya

[Aditya_Chitale]

@anat 

Tried that. But its giving min date for all customers. I want only for ABC

Regards,

Aditya

[MayilVahanan]

Hi

Try like this for specific customer in back end

load customername,min(Date) resident test

where customername = 'ABC' group by customername;

or, in front end, try like

Min({<customername = {'ABC'}>}Date)