Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Calculating minimum of data at load script

Hello everyone,

Please help me with the below data set:-

All the fields are coming from backend:-

Aspiring_Developer_0-1598533895559.png

 

My requirement is:

if minimum of Average hourly Rate f(considering all Year) =0, '' , Min(Average Hourly Rate)

 

I can find the minimum Average Hourly Rate but don't know how to do it for each year like take the minimum values for all years and then compare it if it is equal to 0 or else.

 

I want to show this in chart as a measure .

Please Please help 

 

Thanks

1 Reply
PrashantSangle

can you post expected output w.r.t. input..

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 🙂