Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philgood34
Creator II
Creator II

FORECAST VS PREVIOUS with a ASOFTABLE

Hi Everybody

I have a asoftable in my loading script

asoft.jpg

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

 

 FORVSPREV.jpg

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

 

 

 

24 Replies
sunny_talwar

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

agni_gold
Specialist III
Specialist III

"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?
philgood34
Creator II
Creator II
Author

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 :

 

PREV.jpg

philgood34
Creator II
Creator II
Author

Sunny ,

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

 

 

 

 

sunny_talwar

Can you try this

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

and let us know what do you see?

philgood34
Creator II
Creator II
Author

LIKE THIS

FYEAR.jpg

no other selection

sunny_talwar

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

sunny_talwar

So the name of the field is EXERCISE? Try this

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

I tried

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

 

no change Smiley Sad