Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please help me how to customize a bar chart axis line.
i have added a industry column in barchart,the industry field consists of records like,
IndustryAgriculture,IndustryBanking,Industryinsurance like that so i want to show in axis like onle
Agriculture,banking,Insurace.
so how can i show like that in bar chart.
Plz Help
May be this in Script
Right(FieldName, len(FieldName)-8) as FieldName
Or use same in Bar chart as Calculation Dimension
May be this in Script
Right(FieldName, len(FieldName)-8) as FieldName
Or use same in Bar chart as Calculation Dimension
Use calculated dimension to remove the unwanted string =Replace(name,'Industry','')
Are expecting like this
This is not good practice. What you do if you have data like below as Caps character to small character
LOAD * Inline [
FieldName
IndustryAgriculture
IndustryBanking
industryinsurance
];
Thanks i got the expected output.
Nice, Can you close this thread by flag Correct Answer.
its not showing the option for correct answer .it is showing only mark helpfull.
If not let it be, Read this for future you will get idea
Qlik Community Tip: Marking Replies as Correct or Helpful