Curve trend

[davidoxi]

Hi ,

I have the following table and calendar
with TU a field calculates

I want to draw a curve (6 months ago, TU) and , like this :

[ankur_abhishek]

Hi ,

Could you please provide the dummy data.

Thanks

Ankur

[shraddha_g]

Try

1. http://branch.qlik.com/#!/project/58cf59cd61d353a813f4a37e

2. http://branch.qlik.com/#!/project/576e530cf27410448ff77606

[davidoxi]

TU =  Sum(Aggr(Count(if(Match([Type de commande], 'URGENT','GROS', 'PVI'), [N° de commande])),[N° de client]))

[davidoxi]

hi

Ankur Abhishek a écrit:

Hi ,

Could you please provide the dummy data.

Thanks

Ankur