month expression

[raadwiptec]

hi

from the data model i get period,Type, actuals data

for Ex:

Period       Type         Actuals

---------      -------       ----------

201801,     A1 ,E1        19920.22.

201802,   C1,K1         2322.33

201803,  C1 ,L1         12122.22

201804   D1 ,W1         2121.11

until current month

For Some reason iam not entitled to change the data model

So my requirement is i need to change 201801 to 201812 for type A1 and show it in a graph. So i should have an option to do this in expression  only..

ant suggestions..

[Peter_Cammaert]

How about a chart that uses Period as dimension (thise are sequential values anyway) and this as an expression:

=Sum({<Period = {">=$(=Year(Today()) & '00')<=$(=Date(Today(), 'YYYYMM'))"}>} IF WildMatch(Type, '*A1*'), Actuals))

[raadwiptec]

hi peter.

Basically the graph shows from 201801 to 201808.. But now we need to make 201801 also as 201812 for A1

[Peter_Cammaert]

Actuals in Dec-2018?

You know that in QlikView: no data = no chart