calculate variation between days and include chart

[silvia_assuncao]

Hi,

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

[MarcoWedel]

71.5MB ?

[Anil_Babu_Samineni]

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

[nagarjuna_kotha]

OMG 75 MB

Can u please share small file that tells ur requirement.

- Nagarjun

[sushil353]

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

[Anonymous]

Use Column label for variance calculation, something like this?

Variance column in QlikView - Stack Overflow

[nagarjuna_kotha]

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

[nagarjuna_kotha]

Note :

Sort the day in Asc Mode.

-Nagarjun

[Anonymous · Accepted solution]

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!

[silvia_assuncao]

Great! worked! thanks