Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mshailaja
Contributor III
Contributor III

show last letters in barchart xaxes

Hi all,

i have to show last leeters in xases of barchart suppose in the  bar chart x axes i have  sum(sales) for the product kalanjalikurthalehenga, i need  in x axs letters as lehenga only, How?

5 Replies
MindaugasBacius
Partner
Partner

Add calculated dimension.

Use Expression like Right(ProductName, 2)

snehamahaveer
Creator
Creator

HI Sailaja,

As Mindaugas mentioned earlier you can use a Right or Mid statement in your calculated dimension for product. However ensure your no of alphabets are consistent across all products.

Not applicable

HI,

If your data as you say is kalanjalikurthalehenga then you need to cleanse the data and bring to a form from the back-end (Script Level).

And as suggested above i recommend that you transform the "Right(ProductName, 2)" in the script level.

I think you need to have delimiters eg:kalanjali-kurtha-lehenga

hope you get the jist.

yoganantha321
Creator II
Creator II

hi,

try with this

=Mid(Fieldname, Len(Fieldname)-2)

Anil_Babu_Samineni

Seems typo error Right(ProductName, 7)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)