Can we prepare a P&L using Interval match in Qlik Sense ?

[senarath]

Hi,

We are in the migration of Qlik View apps to Qlik Sense. There are several P&L statements that we have prepared in Qlik View by using Interval match function.

When we tried the same thing in Qlik Sense, it did not work. We retrieve data from our back end (Oracle DB)

Please let us know how to handle a such situation where we want to make a P&L statements in general format.

Thank You

Senarath

[simondachstr · Accepted solution]

I assume you are using Interval Match in the script? It should work like for like. Make sure you specify the same data sources as in QlikView when loading the data.

[sunny_talwar]

If it worked in QlikView, I see no reason why it wouldn't work in Qlik Sense. Is there anything else that might have changed? like the numbers/dates getting changed to text which are getting used for intervalmatch?

[senarath]

Thanks for both... it worked.