barchart customization

[dathathreya]

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

[Anil_Babu_Samineni · Accepted solution]

May be this in Script

Right(FieldName, len(FieldName)-8) as FieldName

Or use same in Bar chart as Calculation Dimension

[Anonymous]

Use calculated dimension to remove  the unwanted string =Replace(name,'Industry','')

[qlikview979]

Are expecting like this

[Anil_Babu_Samineni]

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

];

[dathathreya]

Thanks i got the expected output.

[Anil_Babu_Samineni]

Nice, Can you close this thread by flag Correct Answer.

[dathathreya]

its not showing the option for correct answer .it is showing only mark helpfull.

[Anil_Babu_Samineni]

If not let it be, Read this for future you will get idea

Qlik Community Tip: Marking Replies as Correct or Helpful