Discussion Board for collaboration related to QlikView App Development.
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?
Add calculated dimension.
Use Expression like Right(ProductName, 2)
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.
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.
try with this
Seems typo error Right(ProductName, 7)