Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to achieve this on Line Chart in Qlikview?

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

Line.PNG

Please Help if Possible. Also tell me how to break this lines.

16 Replies
Not applicable
Author

I want exactly the same Vineeth but unable to open your qvw.

Not applicable
Author

Erroe.PNG

vinieme12
Champion III
Champion III

do you have Qliksense?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Yes, I have that too!

vinieme12
Champion III
Champion III

will upload a qliksense sample later

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Hello Vineeth,

Please help through this. Really important.

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.