Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I dont know how could i do this... dinamic dimensions

I have to create something similar to this:

DATA FROM SQL

variable date start = 25/10/2013

TABLA SALES

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

Sale date   |    Value

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

05/05/2013     1000

08/07/2013       500

30/11/2013       300

25/02/2014     1000

I NEED SALES FROM date start to 6 month  with column  with total for previous months

YEAR:                              2013                             2014

MONTH    Prev         Oct       Nov        Dec            Jan        Feb      Mar

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

SALES     1500         0         300            0              0           1000       0

Any idea please

Im so desesperate

Thanks

0 Replies