topic Re: Set Analysis in QlikView

Set Analysis

rido1421 — Sun, 15 Feb 2015 16:16:39 GMT

Hi There

Please could you assist me

I am trying to Create an expression to sum my forecasts if the month selection is greater than or equal to the current month

Sum({<[Fiscal Month]={">=$(vCM)"}>}Forecast) --- This will give you the sum of all the months greater than or equal to the current month

I only want to sum the selected month if the month or months selected is greater than the current month

Thanks

Re: Set Analysis

rido1421 — Sun, 15 Feb 2015 16:19:17 GMT

vCM==(Mod((Month(Date(Date#((Today()),'YYYY/MM/DD'),'DD/MM/YYYY')))-$(vFM), 12)+1 )

vFM=10

Re: Set Analysis

Anonymous — Sun, 15 Feb 2015 16:42:03 GMT

Hi Rido,

Try:

vCM = Month(Today());

Sum({<[Fiscal Month] = {">=$(vCM)<=$(max([Fiscal Month]))"}>}Forecast)

Regards

Neetha

Re: Set Analysis

rido1421 — Sun, 15 Feb 2015 16:47:45 GMT

Hi Neetha

That doesnt seem to work...

Re: Set Analysis

rido1421 — Sun, 15 Feb 2015 16:49:03 GMT

I also have to keep my vCM as my Fiscal month....

Re: Set Analysis

Anonymous — Sun, 15 Feb 2015 16:50:29 GMT

Hi Rido,

When you select a month what is the output,

if less than month selected/greater than month selected.

Re: Set Analysis

rido1421 — Sun, 15 Feb 2015 17:01:05 GMT

Hi Neetha

It is giving a blank result .

This gives a result.. Sum({<[Fiscal Month]={">=$(vCM)<=$(vMAXMTH)"}>}Forecast)

it should do the same as you posted?

when selecting individual months eitherway greater or lower than current the figures are incorrect as well as when selecting multiple months

The reason I need to do this is because I want to sum the actual sales amounts prior to the current month

and add it to the Forecast figures of the future months , so that when selecting multiple months past currrent and future month you will get correct figures.

Re: Set Analysis

Anonymous — Sun, 15 Feb 2015 17:22:52 GMT

if you select greater than today month you are getting empty results,am i right?

Re: Set Analysis

rido1421 — Mon, 16 Feb 2015 05:05:42 GMT

Hi Neetha

No it doesnt give empty results... but the amount is not correct...