Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

silvia_assuncao
Contributor

Chart with variation between days

Hi!

I have a chart with values per day and asset code. And I'd like to have the variation from one day to the other for each asset code.

how can I do it?

1 Solution

Accepted Solutions

Re: Chart with variation between days

Then try this:

Aggr(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)-Above(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)), ASSET_CODE, DAY)

View solution in original post

4 Replies

Re: Chart with variation between days

Is this the goal?

Capture.PNG

Expression:

Aggr(Sum(VALUE)-Above(Sum(VALUE)), ASSET_CODE, DAY)

silvia_assuncao
Contributor

Re: Chart with variation between days

My origninal expression has some setanalysis, how can do as you did above in this case?

(SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100))

Re: Chart with variation between days

Then try this:

Aggr(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)-Above(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)), ASSET_CODE, DAY)

View solution in original post

silvia_assuncao
Contributor

Re: Chart with variation between days

worked!

thanks