topic Re: insert a max date tfrom Vente to Articles in App Development

insert a max date tfrom Vente to Articles

QlikTonic — Mon, 06 May 2019 20:43:51 GMT

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

dplr-rn — Mon, 06 May 2019 21:50:45 GMT

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 — Mon, 06 May 2019 21:54:45 GMT

Many many thanks

Have a nice end of day ¨!

QlikTonic — Mon, 06 May 2019 21:56:39 GMT

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