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.
See this post, you just have to change the chart type
Period Presets: Compare Periods on the fly | Qlik Community
it is already developed by one of my collegue in prev organization in qlikview so it is possible.
have you checked the link!
I want it in Line chart and also want to break those lines.
Can you provide a sample app or sample data?
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.
Now further how to create only one expression for top 5 manufacturer and also breaking the line ??
Please Help
May be use background color to turn the line white between the segments
See attached sample
Hello Vineeth,
Unable to open the file on the personal edition.
any other option?