Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

Pie chart rename a column filed

Hi,

Is possible to rename in a pie chart a field from a column?

ex:

table:

id,

customer,

status

from txt.qvd

I have the column  'customer' which contain 5 customers like :aaa, bbb, ccc, ddd, eee, fff


I would like if is possible in my pie chart to rename the customer fff to be xxx.


Is this possible in qlikview?


Kind regards

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Script Solution

table:

id,

If(Match(customer,'aaa'),'fff', customer) as customer,

status

from txt.qvd

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

6 Replies
Anil_Babu_Samineni

Script / Front End ???

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Frank_Hartmann
Master II
Master II

try like this:

If(match(customer,'fff'),'xxx',customer)

Anil_Babu_Samineni

Script Solution

table:

id,

If(Match(customer,'aaa'),'fff', customer) as customer,

status

from txt.qvd

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
0li5a3a
Creator III
Creator III
Author

I would like front end

prma7799
Master III
Master III

Write it is in your expression


If(Match(customer,'aaa'),'fff', customer)


Or

If(WildMatch(customer,'aaa'),'fff', customer)


0li5a3a
Creator III
Creator III
Author

Thank you for your answer I used to the end the script.