topic Re: margens in QlikView

margens

bbmmouha — Mon, 02 Jul 2018 14:42:22 GMT

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 — Mon, 02 Jul 2018 15:59:31 GMT

May be this?

Dimension - Week

Expression -

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

bbmmouha — Tue, 03 Jul 2018 07:31:44 GMT

thank you anil

i whant Something like that

Anil_Babu_Samineni — Tue, 03 Jul 2018 11:53:42 GMT

What are the J4 and J7

BalaBhaskar_Qlik — Tue, 03 Jul 2018 17:17:58 GMT

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

vishsaggi — Tue, 03 Jul 2018 17:57:49 GMT

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

bbmmouha — Wed, 04 Jul 2018 07:29:44 GMT

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

bbmmouha — Wed, 04 Jul 2018 14:56:31 GMT

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 — Mon, 09 Jul 2018 07:09:47 GMT

any help please

bbmmouha — Tue, 10 Jul 2018 09:19:01 GMT

i got it finally if this can help anyone

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

above() function it return the value of previous ligne