FORECAST VS PREVIOUS with a ASOFTABLE

[philgood34]

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

[agni_gold]

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

[sunny_talwar]

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

[philgood34]

Like this ?

 

[philgood34]

i tried

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

no change

[sunny_talwar]

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

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

[philgood34]

i tried 

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

or

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

FYEAR appears as a champ

But no change ...

[philgood34]

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 ?

[sunny_talwar]

---

@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 🙂

[philgood34]

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 ...

[sunny_talwar]

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