Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
vinieme12
Esteemed Contributor II

Re: How to achieve this on Line Chart in Qlikview?

See this post, you just have to change the chart type

Period Presets: Compare Periods on the fly | Qlik Community

Not applicable

Re: How to achieve this on Line Chart in Qlikview?

it is already developed by one of my collegue in prev organization in qlikview so it is possible.

vinieme12
Esteemed Contributor II

Re: How to achieve this on Line Chart in Qlikview?

have you checked the link!

Not applicable

Re: How to achieve this on Line Chart in Qlikview?

I want it in Line chart and also want to break those lines.

MVP
MVP

Re: How to achieve this on Line Chart in Qlikview?

Can you provide a sample app or sample data?

Not applicable

Re: How to achieve this on Line Chart in Qlikview?

Hello Sunny,

Finally I am using valuelist() in dimension but now I have to break the line between the year and YTD any idea how to do that?

Also the Expression should be only one showing top five MANUFACTURE_NAME only on the line it means dynamic

so far the logic I used is

Dimension

ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')

Measure

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='2014',sum({<[0CALYEAR_RMS]={'2014'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='2015',sum({<[0CALYEAR_RMS]={'2015'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='2016',sum({<[0CALYEAR_RMS]={'2016'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='','',

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='','',

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='YTD-15',sum({<[0CALYEAR_RMS]={'2015'},CALC_FLAG_RMS={'YTD'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='YTD-16',sum({<[0CALYEAR_RMS]={'2016'},CALC_FLAG_RMS={'YTD'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='01',sum({<[0CALMONTH2_RMS]={'01'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='02',sum({<[0CALMONTH2_RMS]={'02'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='03',sum({<[0CALMONTH2_RMS]={'03'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='04',sum({<[0CALMONTH2_RMS]={'04'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='05',sum({<[0CALMONTH2_RMS]={'05'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='06',sum({<[0CALMONTH2_RMS]={'06'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='07',sum({<[0CALMONTH2_RMS]={'07'}>}ZABR_SVAL),

if(ValueList('2014','2015','2016','','','YTD-15','YTD-16','','','01','02','03','04','05','06','07','08')='08',sum({<[0CALMONTH2_RMS]={'08'}>}ZABR_SVAL))))))))))))))))

It is giving me the desired output.

Capture1.JPG

Now further how to create only one expression for top 5 manufacturer and also breaking the line ??

Please Help

MVP
MVP

Re: How to achieve this on Line Chart in Qlikview?

May be use background color to turn the line white between the segments

vinieme12
Esteemed Contributor II

Re: How to achieve this on Line Chart in Qlikview?

See attached sample

lineBreakSample.JPG

Not applicable

Re: How to achieve this on Line Chart in Qlikview?

Hello Vineeth,

Unable to open the file on the personal edition.

any other option?