topic Re: FORECAST VS PREVIOUS with a ASOFTABLE in App Development

FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 13:51:54 GMT

Hi Everybody

I have a asoftable in my loading script

I have a measure called CATTC (instead of "SALES")

In a tab, i want to have a comparaison between FORECAST CATTC and PREVIOUS YEAR

for all the next year

My issue :

As you can see, when the current datas are not yet imported (since February), the previous datas are not shown while they are there.

Here is my expression :

For the previous year datas

Sum({<Flag = {'PY'}>}VMS_CATTC)

for the forecast datas

Sum({<Flag = {'GOAL'}>}VMP_CATTC)

An idea to solve my issue ?

thanks in advance

REGARDS

Philippe

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 14:13:05 GMT

When you took the snapshot of the chart, were you making selection in any date and time related fields? or any other fields?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

agni_gold — Fri, 25 Jan 2019 14:19:49 GMT

"when the current datas are not yet imported (since February), the previous datas are not shown while they are there."

Can you explain bit clearly, what you want to achieve?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 14:32:14 GMT

I explain :

in my snapshot, you see the current datas over the périod November to January.

of course, i made the forecast for all the period (11/2018 to 10/2019)

and of course, the prévious data are known and imported

But as you see, previous data only appear if current datas are present ???

I would like the previous datas to be visible in the table over the entire period, even if the current data is not yet imported

here :

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 14:38:04 GMT

Sunny ,

I just selected the fiscal year (11/2018 to 09/2019)

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 14:40:09 GMT

Can you try this

Sum({<Flag = {'PY'}, [fiscal year]>}VMS_CATTC)

and let us know what do you see?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 14:40:44 GMT

LIKE THIS

no other selection

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 14:40:45 GMT

This may give you everything for previous year expression... but that will help determine the issue and we can work on it further

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 14:43:18 GMT

So the name of the field is EXERCISE? Try this

Sum({<Flag = {'PY'}, [EXERCISE]>}VMS_CATTC)

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 14:49:00 GMT

I tried

Sum({<Flag = {'PY'}, fYear>}VMS_CATTC)

no change

Re: FORECAST VS PREVIOUS with a ASOFTABLE

agni_gold — Fri, 25 Jan 2019 14:50:22 GMT

better if you could share app , this will help us to resolve your issue

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 14:57:05 GMT

Snapshot showes EXCERCISE, is the field fyear? can you show an image of current selection up top?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 15:01:34 GMT

Like this ?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 15:05:02 GMT

i tried

Sum({<Flag = {'PY'},EXERCICE >}VMS_CATTC)

no change

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 15:06:26 GMT

Qlik Sense is case sensitive... can you try this

Sum({<Flag = {'PY'}, FYear>}VMS_CATTC)

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 15:12:45 GMT

i tried

Sum({<Flag = {'PY'},[FYear]>}VMS_CATTC)

Sum({<Flag = {'PY'},FYear>}VMS_CATTC)

FYEAR appears as a champ

But no change ...

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 15:21:06 GMT

When the CURRENT data exists, no problème PY = MONTH of YEAR - 1

But when CURRENT data does not exists, QLIK should understand that PY = MONTH of GOAL- 1

Maybe ?

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 16:03:04 GMT

@philgood34 wrote:
i tried
Sum({<Flag = {'PY'},[FYear]>}VMS_CATTC)
or
Sum({<Flag = {'PY'},FYear>}VMS_CATTC)

FYEAR appears as a champ

But no change ...

FYEAR appears as a champ? But no change.... that seems contradicting 🙂

Re: FORECAST VS PREVIOUS with a ASOFTABLE

philgood34 — Fri, 25 Jan 2019 16:12:17 GMT

I mean no change for my issue

In fact , there is a change , all years appear despite my year selection is always only the FYEAR ...

Re: FORECAST VS PREVIOUS with a ASOFTABLE

sunny_talwar — Fri, 25 Jan 2019 16:18:38 GMT

Not sure what might be going on. Would you be able to share a sample to check this out?