Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get data corresponding to last month

Hi All,

I have data in the following format:

Date               Value

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

11-Nov-2013    1000

12-Nov-2013    1500

01-Dec-2013     700

02-Jan-2014      900

I need an expression to get the ratio of values in the following manner:

Date               Ratio Value

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

11-Nov-2013    ---

12-Nov-2013    ---

01-Dec-2013     700/1000(Current Month's value/ Last month's latest value)

02-Jan-2014      900/700  (Current Month's value/ Last month's latest value)

Is this possible through expressions in Table Chart?

1 Reply
Not applicable

Hey Sudeep,

You can achieve it through Set analysis if you want to do it on the front end.

But I usually try to do all calculations on the back-end for performance reasons. Every calculation that Qlikview performs on the front end eats up memory.

The file attached shows how to do it on the back end.

Hope it helps you.