topic Re: How to normalize data in a graph in QlikView

How to normalize data in a graph

Wed, 15 Jun 2016 11:02:10 GMT

Hello all,

I have 3 columns of data: Fundname, date and value. The user can select the initial and final dates of the graph which are stored in the variables InitialDate and FinalDate. I would like to show the value of each fund so that in the InitialDate its value was 100, but I am unable to do that. By the moment I have this in the expression:

value*100*if(date>=InitialDate,1,0)*if(date<=Finaldate,1,0)/( {<date={'$(InitialDate)'}>}value)

And as dimensions of the line chart Date and Fundname.

Anyone could help?

Thanks a lot!

Re: How to normalize data in a graph

sunny_talwar — Wed, 15 Jun 2016 13:40:16 GMT

May be something like this:

value*100*if(date>=InitialDate,1,0)*if(date<=Finaldate,1,0)/( {<date={'$(InitialDate)'}>}value)

FirstSortedValue(TOTAL <Fundname> Aggr(value*100*if(date>=InitialDate,1,0)*if(date<=Finaldate,1,0)/( {<date={'$(InitialDate)'}>}value), Date,Fundname), Aggr(Date, Date,Fundname))

Re: How to normalize data in a graph

jonathandienst — Wed, 15 Jun 2016 13:47:16 GMT

I would try something like:

Sum({<date={">=$(=InitialDate) <=$(=FinalDate)"}>} value) /

Sum({<date={'$(InitialDate)'}>} total value)

Re: How to normalize data in a graph

Fri, 17 Jun 2016 09:55:55 GMT

Hi Sunny, it does not show any graph, any idea?

Re: How to normalize data in a graph

sunny_talwar — Fri, 17 Jun 2016 10:35:21 GMT

Would you be able to share a sample to test it out?

Preparing examples for Upload - Reduction and Data Scrambling

Re: How to normalize data in a graph

jonathandienst — Mon, 20 Jun 2016 07:49:00 GMT

Did you try my suggestion above?

Re: How to normalize data in a graph

Mon, 20 Jun 2016 09:31:57 GMT

Yes, it didn't work, I approached the solution by creating a temporary 8-column table, that for my purpose works, as no more series will be inserted, but it is not the correct solution.