topic Re: calculate variation between days and include chart in QlikView

calculate variation between days and include chart

silvia_assuncao — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart with values by day and I'd like to include the variations between the current and previous days.

Re: calculate variation between days and include chart

MarcoWedel — Wed, 28 Sep 2016 22:35:37 GMT

71.5MB ?

Re: calculate variation between days and include chart

Anil_Babu_Samineni — Thu, 29 Sep 2016 05:55:39 GMT

Would you share the expression which you wrote overthete, because the file size is huge. And after that tell that which you face the problem I that graph

Re: calculate variation between days and include chart

nagarjuna_kotha — Thu, 29 Sep 2016 06:02:43 GMT

OMG 75 MB

Can u please share small file that tells ur requirement.

- Nagarjun

Re: calculate variation between days and include chart

sushil353 — Thu, 29 Sep 2016 06:07:06 GMT

Hi,

If you simply want to show the difference of two consecutive rows of information (day to day) the you can use above() function in your chart..

or share the expression with more clear requirement..

HTH

Sushil

Re: calculate variation between days and include chart

Anonymous — Thu, 29 Sep 2016 06:18:03 GMT

Use Column label for variance calculation, something like this?

Variance column in QlikView - Stack Overflow

Re: calculate variation between days and include chart

nagarjuna_kotha — Thu, 29 Sep 2016 06:20:33 GMT

Hi I have checked ur application:

May be like this?

Try this...

=If(Aggr(NODISTINCT RowNo(), [DIA PREGAO],[CODNEG - CÓDIGO DE NEGOCIACAO DO PAPEL]) > 0, RangeSum((SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}([PREULT - PREÇO DO ÚLTIMO NEGÓCIO DO PAPEL-MERCADO NO PREGÃO])/100)) - Above(TOTAL (SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}([PREULT - PREÇO DO ÚLTIMO NEGÓCIO DO PAPEL-MERCADO NO PREGÃO])/100)))))

It will give you the diff between previous day to current day.

I hope this may help.

- Nagarjun

Re: calculate variation between days and include chart

nagarjuna_kotha — Thu, 29 Sep 2016 06:22:07 GMT

Note :

Sort the day in Asc Mode.

-Nagarjun

Re: calculate variation between days and include chart

Anonymous — Thu, 29 Sep 2016 08:25:33 GMT

Hi Silvia,

Use above to calculate de variance.

(SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}([PREULT - PREÇO DO ÚLTIMO NEGÓCIO DO PAPEL-MERCADO NO PREGÃO])/100))-

Above((SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}([PREULT - PREÇO DO ÚLTIMO NEGÓCIO DO PAPEL-MERCADO NO PREGÃO])/100)))

And on CODNEG - CÓDIGO DE NEGOCIACAO DO PAPEL put a conditional view:

With this condition: iF(GetSelectedCount([CODNEG - CÓDIGO DE NEGOCIACAO DO PAPEL])=1,False(),True())

Regards!

Re: calculate variation between days and include chart

silvia_assuncao — Thu, 29 Sep 2016 12:26:17 GMT

Great! worked! thanks

Re: calculate variation between days and include chart

Anonymous — Thu, 29 Sep 2016 12:31:25 GMT

You're wellcome!