Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
Contributor III

insert a max date tfrom Vente to Articles

Hi everybody,

 

I spent hours but i don't find solution and i need your help please !

 

i would like to insert in my articles table the max date of sold articles from my vente table.

How to do that please ?

Many thanks

articles.PNG

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

why do you want to add it into the article s table?

You can easily find it in ui if you have article as dimension and max(date) .

But if you really want it. Create a temp table which will find max per article and join it to the article table.

E.g.

Left join (articles)

Load articleid, max(datevente) as [Max Ventes]

Resident Ventes group by articleid

 

Codee is rough. I am typing on my phone but concept remains

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

why do you want to add it into the article s table?

You can easily find it in ui if you have article as dimension and max(date) .

But if you really want it. Create a temp table which will find max per article and join it to the article table.

E.g.

Left join (articles)

Load articleid, max(datevente) as [Max Ventes]

Resident Ventes group by articleid

 

Codee is rough. I am typing on my phone but concept remains

QlikTonic
Contributor III
Contributor III
Author

Many many thanks

Have a nice end of day ¨!

c.

QlikTonic
Contributor III
Contributor III
Author

I wanted to count the number of article not sold since 90 days

thanks to your answer i can now do it

All the best and thanks again

c.