Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Snapshot showes EXCERCISE, is the field fyear? can you show an image of current selection up top?
Like this ?
i tried
Sum({<Flag = {'PY'},EXERCICE >}VMS_CATTC)
no change
Qlik Sense is case sensitive... can you try this
Sum({<Flag = {'PY'}, FYear>}VMS_CATTC)
i tried
Sum({<Flag = {'PY'},[FYear]>}VMS_CATTC)
or
Sum({<Flag = {'PY'},FYear>}VMS_CATTC)
FYEAR appears as a champ
But no change ...
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 ?
@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 🙂
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 ...
Not sure what might be going on. Would you be able to share a sample to check this out?