Qlik Community

Qlik Sense App Development

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

QlikTonic
New Contributor II

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
Partner
Partner

Re: insert a max date tfrom Vente to Articles

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

3 Replies
Partner
Partner

Re: insert a max date tfrom Vente to Articles

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
New Contributor II

Re: insert a max date tfrom Vente to Articles

Many many thanks

Have a nice end of day ¨!

c.

QlikTonic
New Contributor II

Re: insert a max date tfrom Vente to Articles

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.