Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to make a chart for RONW%

Hii All,

I am trying to make a chart in which dimension is 12 months starting from jan,feb...

an expression is formula for RONW% for each month.

and my dimension is stored in the form of:

str_fy     str_fy_month     str_fy_hy     str_fy_qtry          RONW(money_measure)

2010     jan                    H1               Q1                         value1

2010     feb                    H1               Q1                         value2

-

-

-

2011     jan                    H1               Q1                         value3

2011     feb                    H1               Q1                         value4

-

-

-

2012     jan                        H1               Q1                    value5

2012     feb                    H1                    Q1                    value6

-

-

-

where where my year is divided into halfyearly and quarterly basis,

so i want to make RoNW% chart for prior year using a variable which store the value of prior year

0 Replies