topic Re: month based in QlikView

month based

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

Hi all,

I have month column , and 2 additional columns Value 1 and value 2

Jan Feb Mar so on,,,,, Dec

Value 1 Value 2 Value 1 Value 2 Value 1 Value 2

200 132 220 125 125 265

My requirement as below

If it is January then Value 1 of January + Value 2 for the rest of months until december(Feb+Mar+Apr+ .,...Dec)

If it is Febrauray then Value 1 of January and Februalry + Value 2 of Mar +apr + may +.......Dec

If it is March then Value 1 of (Jan+Feb+Mar) + Value 2 of ( Apr+ May + Jun +..... Dec)

Re: month based

raadwiptec — Wed, 06 Jul 2016 14:46:39 GMT

any suggestions? here

raadi

Re: month based

sunny_talwar — Thu, 07 Jul 2016 03:11:18 GMT

Would you be able to provide a Excel based sample with more data points and the expected output here?

Re: month based

raadwiptec — Thu, 07 Jul 2016 08:26:11 GMT

Hi sunny,

the sample file looks like this.. i already found a solution but interested to know what are the other ways...

Re: month based

sunny_talwar — Thu, 07 Jul 2016 12:16:57 GMT

This sample looks slightly different then what you asked above. I don't see Feb, Mar....? What is the expected output for the sample you have provided?

Re: month based

raadwiptec — Thu, 07 Jul 2016 12:24:42 GMT

Hi sunny

already this data is loaded.. into QVD. From there on I need the solution similiar as below

Value 1 and value 2 corresponds to the Estimate and definite

an Feb Mar so on,,,,, Dec

Value 1 Value 2 Value 1 Value 2 Value 1 Value 2

200 132 220 125 125 265

My requirement as below

If it is January then Value 1 of January + Value 2 for the rest of months until december(Feb+Mar+Apr+ .,...Dec)

If it is Febrauray then Value 1 of January and Februalry + Value 2 of Mar +apr + may +.......Dec

If it is March then Value 1 of (Jan+Feb+Mar) + Value 2 of ( Apr+ May + Jun +..... Dec)