topic Re: Previous Date in QlikView

Previous Date

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

Hi All,

I have a straight table ...

Now i need to show the sum of revenue for all the months of 2017 and the first 2 rows of the Date field at the topshould show, 2 privios yers revenue that is for 2015 and 2016 and then all the months of 2017 as shown in the image

how can i achieve this please find the attachment and snapshot and the excel file

For current year ( 2017) show the Revenue monthly wise and for previous Years (2015 and 2016) we need show the revenue as monthly avaerge.

Under date field the firts 2 rows should show previous year(2015 and 2016 ) and then current years full month

Please someone suggest me

Tahnks in advance

Re: Previous Date

techvarun — Wed, 30 Aug 2017 05:39:55 GMT

Hi,

check the attached.

Re: Previous Date

techvarun — Wed, 30 Aug 2017 05:41:41 GMT

Re: Previous Date

smilingjohn — Wed, 30 Aug 2017 05:52:34 GMT

Hi Varun thanks for the reply ...

I am attaching a excel file how do we handle this here ???

U have got the result from inline table

For current year show the data monthly wise and for previous yesr we need show the revenue as monthly avaerge

Re: Previous Date

techvarun — Wed, 30 Aug 2017 05:57:49 GMT

Also share the expected output table format and numbers

Re: Previous Date

smilingjohn — Wed, 30 Aug 2017 06:30:35 GMT

Hi Varun

there is no sample output ...

What you showed above that is how it should look like

but with the excel sheet i have shared

Re: Previous Date

techvarun — Wed, 30 Aug 2017 07:19:04 GMT

Is this what are you looking for?

Re: Previous Date

smilingjohn — Wed, 30 Aug 2017 07:28:11 GMT

Hi Varun ..

Do i need to keep entering in the futre till 2018 19 ans so inLine table ?

Is ther no other way doing this at expression table ?

Re: Previous Date

smilingjohn — Wed, 30 Aug 2017 07:31:12 GMT

for previous years it shoul be like AVG(Revenue)

and for current year which will diplsay all the month should be Sum(Revenue ) ..

I dont know how to get this

Re: Previous Date

techvarun — Wed, 30 Aug 2017 07:37:24 GMT

try

If([New Date] = '2015' OR [New Date] = '2016', Avg(Revenue), sum(Revenue))

OR simply

Avg(Revenue)

should work

Re: Previous Date

antoniotiman — Wed, 30 Aug 2017 07:38:09 GMT

Hi John,

see Attachment.

Regards,

Antonio.

Re: Previous Date

smilingjohn — Wed, 30 Aug 2017 08:48:20 GMT

Thanks Antonio

You are genius it works for me

Re: Previous Date

antoniotiman — Wed, 30 Aug 2017 08:51:39 GMT

Thanks John,

I'm glad to helped You.

Regards,

Antonio