margens

[bbmmouha]

hello

i want to do this the margen between sum( today() sales )  and sum( today()-7 sales ) by week

thanks for helps

[Anil_Babu_Samineni]

May be this?

Dimension - Week

Expression -

Sum({<DateField = {"=Today()"}>} Sales)-Sum({<DateField = {"=Today()-7"}>} Sales)

[bbmmouha]

thank you anil

i whant Something like that

[Anil_Babu_Samineni]

What are the J4 and J7

[balabhaskarqlik]

Check the values / measures of J - 14 and j - 7. There you need to modify expression.

[vishsaggi]

What is the format in Date_Test? What are the values in J field?

[bbmmouha]

date_test is 'DD/MM/YYYY' , j-7 and j-14 are date_test-7 and date_test-14

[bbmmouha]

this exctly what i want to do the margine between sum(quantite) for this week and the sum(quantitie) of previous week

thank you for help i'm reely stuck

[bbmmouha]

any help please

[bbmmouha · Accepted solution]

i got it finally if this can help anyone

Sum(quantite)-Above(Sum(quantite))

above() function it return the value of previous ligne

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterReco...