topic Re: barchart customization in QlikView

barchart customization

dathathreya — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 15 May 2017 06:29:47 GMT

May be this in Script

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

Or use same in Bar chart as Calculation Dimension

Anonymous — Mon, 15 May 2017 06:31:18 GMT

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

qlikview979 — Mon, 15 May 2017 06:33:24 GMT

Are expecting like this

Anil_Babu_Samineni — Mon, 15 May 2017 06:35:37 GMT

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 — Mon, 15 May 2017 06:37:08 GMT

Thanks i got the expected output.

Anil_Babu_Samineni — Mon, 15 May 2017 06:38:32 GMT

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

dathathreya — Mon, 15 May 2017 06:39:58 GMT

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

Anil_Babu_Samineni — Mon, 15 May 2017 06:42:27 GMT

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