topic Re: stright table ? in QlikView

stright table ?

Wed, 25 Nov 2020 16:16:04 GMT

Date	sales
1/1/2014	100
12/1/2014	200
2/3/2015	222
12/1/2015	323
4/5/2016	345
12/1/2016	444
12/23/2016	789

Hi I have one table with above 2 columns ,

i have ploted a stright table with dimension is Date and measure is sum(sales), here my requirmnet isi have to create another expression

with calculation is

sum(sales)/previous year highest month sales which means

formula:

sum(sales)/previous year highest month sales

ex:

when Date is 1/1/2014 it will look for previous year highest month ,in that case it doesn't have any year values so it is going to be blank.

like wise

if u see for 2/3/2015 values is 222

and previous year value is 200

here the calculation should be like 222/200

like this i want write a expression for dynamic calculation

Re: stright table ?

tripatirao — Sat, 11 Mar 2017 05:22:12 GMT

Hi ,

Please refer this.

From this you can get solution

Peek() vs Previous() – When to Use Each

Re: stright table ?

Sat, 11 Mar 2017 13:24:03 GMT

Hi,

Thanks for looking in to this

i want do this in straight table

Re: stright table ?

Frank_Hartmann — Sun, 12 Mar 2017 16:25:09 GMT

hi,

have a look at the attached sample.

hope this helps!

Re: stright table ?

Mon, 13 Mar 2017 04:08:00 GMT

Hi Frank Hartmann,

It is very close to the result,

its giving result as per current data ,if I add more records then giving wrong result,

let say I have added one more record called 12/10/2015 330

in this case ur picking max value but I want choose the max date value(not maximum value)

pls let me know if ur not understanding myrequirement

Re: stright table ?

hemachandran — Mon, 13 Mar 2017 06:37:19 GMT

Hi Frank Hartmann,

You need to pick previous year max date value..In your case...

Re: stright table ?

Frank_Hartmann — Mon, 13 Mar 2017 08:36:17 GMT

Im not sure what you expect if you add the line

12/10/2015

330

like this?

if not, please show expected output!

Re: stright table ?

Mon, 13 Mar 2017 09:50:46 GMT

hi Frank,

when I add new record called 12/10/2015 300 (not 330)

in this ur picking max value which will pick the date of (12/01/2015) but my intention is pick the max date value (12/10/2015)

Re: stright table ?

Frank_Hartmann — Mon, 13 Mar 2017 10:46:55 GMT

here you go.

have a look at attached qvw.

hope this helps