Just started QlikSense this week, have a query. I have a line chart of total accounts # where "number of accounts" originated from a particular Quarter (example 2015 Q4, 2016 Q1, 2016 Q2 etc.) is shown per "Month on Book" (0,1,2,3 etc.) . So my line chart is simply below which has two dimensions: QTR_VINTAGE and MOB.
In the Chart, number of accounts originated from a specific vintage is plotted per "Month on Book".
Now my requirement is for Month on Book = 1, I want to show the value from "Month on Book" when 0 which is one point prior. For MOB=0, it should keep the same value. From MOB=1 onwards it should plot one lagged value that is, from (MOB-1).
I can do this easily in Data and load it to show in Chart but I really want to handle this using function/script in Qlik Sense itself. Can you please advise?
Hi, like this last column D, I need to plot for each column "A" values per MOB on X Axis. The MOB=0 value is plotted without any transformation but MOB=1 onwards it is one value lagged. Hope this clarifies.
Actually, I was also trying to see if there is any direct function I can use in the chart script directly. Because I am anyway creating data outside and feeding into the project. I can always create a lagged variable in data; I am trying to find out if there is a way it can be coded up directly in the chart scripting.