Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

display the line with min (Sales)

Hello I have this code and I want to display in a table object only the row with the minimum sales via a flag 

Table1:
Load * Inline [
Risque_id,Nom,Sales
1,Ahmed,100
2,Taxi,200
3,Hendo,300];

right join

Table2:
Load * Inline [
Risque_id,Country,agee,Language,date_birthday,agee_min

1,USA,77,English,03/04/2000,77
3,France ,99,French,05/07/2017,99

];

 

 

left Join (Table3)
Load
Distinct
Risque_id,
Min(Sales),

 

1 as flagmin

resident Table1
Group by Risque_id;

 Thanks for help 

1 Solution

Accepted Solutions
zied_ahmed1
Specialist
Specialist
Author

this is simply the solution 

 


left Join (Table_final)
Load
Distinct

min (Sales) as Sales,

1 as flagmin

resident Table_final;

View solution in original post

3 Replies
Anil_Babu_Samineni

Something like this?

Sum({<flagmin={1}>} Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zied_ahmed1
Specialist
Specialist
Author

Hello with this code for the flag will display only 1 

zied_ahmed1
Specialist
Specialist
Author

this is simply the solution 

 


left Join (Table_final)
Load
Distinct

min (Sales) as Sales,

1 as flagmin

resident Table_final;