Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to change the dimension value name in the chart

Hi, I was doing a check and got the below doubt. Could somebody help me on this?

I have two data sets for example as below kept in two tabs of the attached excel file. In the first tab, I have EmpID and Name. In the second tab, I have EmpID, Salary, and some other fields.

The issue is there are some EmpID whose name is not present but salary and other details are present. So, when I create a bar graph with Name as dimension and Sum(Salary) as expression, I got a dash symbol for the salary whose names are not there in my database. I want to change the dash symbol to some other word such as 'Unknown'. How to change it?

Please find the source data in two tabs of the Excel file and my chart as an image below.

1 Solution

Accepted Solutions
passionate
Valued Contributor

Re: How to change the dimension value name in the chart

You can use calculated Dimension like attached:

3 Replies
neelamsaroha157
Valued Contributor II

Re: How to change the dimension value name in the chart

You can add if condition in your script as

If(isNull(Name) or Len(Name)<1, 'Unknown', Name) as NewNameField

passionate
Valued Contributor

Re: How to change the dimension value name in the chart

You can use calculated Dimension like attached:

Not applicable

Re: How to change the dimension value name in the chart

Hi Neelam,

Thanks for your reply. But the issue is in the Emp1 tab, there are no null values in Name field. There are less number of records. If there is null values, then the script you mentioned will help definitely.

Community Browser