Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
How to achieve this on line chart on qlikview. I have the following fields
Dimensions-
CALMONTH: 01,02,03 etc.
CALYEAR: 2013,2014,2015
CAL_YTD: FY,YTD.
Measure-
SVAL
Please Help if Possible. Also tell me how to break this lines.
I want exactly the same Vineeth but unable to open your qvw.
do you have Qliksense?
Yes, I have that too!
will upload a qliksense sample later
Hello Vineeth,
Please help through this. Really important.
OK! im not able to create a qliksense app but i'll tell you what I did
//// In script ////////////////
Load the preset calendar(Refer link above)
also load a small island table as below
temp_DIM: // this will generate number list from 1 to 5
LOAD Rowno() as DIM
Autogenerate(5) ;
//////////// Front End ///////////////////
Chart Dimension
=Pick(DIM,if(PeriodCat='FullYear',Period)
,' ' //DIM =2 , 1 blank space
,if(wildmatch(PeriodCat,'*YTDFlag'),Period)
,' ' //DIM =4 , 2 blank space
,if(PeriodCat='YearMonth',Period))
Expressions (one expression for each line category)
exp(1.1)
if(DIM=1,
sum({<Dim1={'A'}>}Expression1)
)
exp(1.2)
if(DIM=1,
sum({<Dim1={'B'}>}Expression1)*.75
)
exp(1.3)
if(DIM=1,
sum({<Dim1={'C'}>} Expression1)*.35
)
exp(2.1)
if(DIM=3,
sum({<Dim1={'A'}>}Expression1)
)
exp(2.2)
if(DIM=3,
sum({<Dim1={'B'}>}Expression1)*.75
)
exp(2.3)
if(DIM=3,
sum({<Dim1={'C'}>} Expression1)*.35
)
exp(3.1)
if(DIM=5,
sum({<Dim1={'A'}>}Expression1)
)
exp(3.2)
if(DIM=5,
sum({<Dim1={'B'}>}Expression1)*.75
)
exp(3.3)
if(DIM=5,
sum({<Dim1={'C'}>} Expression1)*.35
)
DIM 1 = Full Year Periods
DIM 2 = Blank
DIM 3 = YTD Periods
DIM 4 = Blank
DIM 5 = Year Months