topic Re: Alias for Dimension in QlikView

Alias for Dimension

Tue, 22 Dec 2015 00:50:46 GMT

Hi, I am wanting to know how to create an alias.

By that, I mean I have a variable property_type which I am using for a dimension in a bar chart.

This has values of house, unit, land etc and I would like to create the value Unknown for null values.

I do not want to do this in the script as the data is relatively unknown, 13 million records and I do not want to reload the script every time I come across something like this.

Thanks in advance.

Re: Alias for Dimension

Tue, 22 Dec 2015 05:08:42 GMT

Solved now. This is the only forum I have seen where a moderator needs to approve a posting.

It has taken 4 hours for that.

Not a great community page.

Re: Alias for Dimension

ajsjoshua — Tue, 22 Dec 2015 05:10:06 GMT

HI,

Do u want to rename property_type in the chart?

Re: Alias for Dimension

mightyqlikers — Tue, 22 Dec 2015 05:12:46 GMT

try this.

if( isnull(variable),'unknown',variable)

regards

$@M

Re: Alias for Dimension

Tue, 22 Dec 2015 05:19:26 GMT

Thanks all, I have solved now. I wanted to assign value to null values and also create list box with new variables which I have worked both out. Unfortunately the post saying this hasn't yet been approved by moderator thus my comment in previous post.

Re: Alias for Dimension

Sun, 17 Jan 2016 21:14:47 GMT

Had to change in the script, which is very primitive. Personally I find this a very cumbersome product in comparison to Tableau.