Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Script Solution
table:
id,
If(Match(customer,'aaa'),'fff', customer) as customer,
status
from txt.qvd
Script / Front End ???
try like this:
If(match(customer,'fff'),'xxx',customer)
Script Solution
table:
id,
If(Match(customer,'aaa'),'fff', customer) as customer,
status
from txt.qvd
I would like front end
Write it is in your expression
If(Match(customer,'aaa'),'fff', customer)
Or
If(WildMatch(customer,'aaa'),'fff', customer)
Thank you for your answer I used to the end the script.