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

Hi everybody, Sunny & Agni

 

I created a new sample app. containing my issue, I hope it will be clearer

 

SAMPLE.jpg

unfortunately, I can not  attach my file app (sample.qvf) ??? 

i read this message :

                                             The contents of the attachment doesn't match its file type.

can you help me please ?

Best regards

Philippe

philgood34
Creator II
Creator II
Author

I try to attach my files as a zip one

philgood34
Creator II
Creator II
Author

GOT IT !
sunny_talwar

So, is your issue resolved? or do you still need help?

philgood34
Creator II
Creator II
Author

No resolved

i sent a app with sample to offer better explanation

did you saw it  ?

regards

Philippe