topic month expression in QlikView

month expression

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 24 Aug 2018 08:36:04 GMT

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 — Fri, 24 Aug 2018 10:21:44 GMT

hi peter.

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

Peter_Cammaert — Fri, 24 Aug 2018 10:25:22 GMT

Actuals in Dec-2018?

You know that in QlikView: no data = no chart