topic Re: How to make a field based on a condition in QlikView

How to make a field based on a condition

Sun, 10 Aug 2014 02:49:50 GMT

Hi I have a dashboard whose datamodel has just one fact table where all the fields are located..I want to create a field named [displayregionflag] which will store a value 'Y' when the following condition is true

WHERE REGION_NAME IN ('AMS', 'EMEA', 'APJ')

and 'N' when not true

is this possible? if yes how?

if yes do I need to create a new script tab and write the code and concatenate it or something with the fact table?

In the end I would like to have the following result in a tablebox

Region_Name displayregionflag

ams Y

emea Y

apj Y

others N

Re: How to make a field based on a condition

aveeeeeee7en — Sun, 10 Aug 2014 04:53:45 GMT

It's better to create a field in the script (Back end). Like this:

if(Match(REGION_NAME,'AMS', 'EMEA', 'APJ'),'Y','N') AS [displayregionflag]

You don't need to create a new tab for this.

Just write this the code in the same table from where you are using REGION_NAME field.

or you can also, do this in front end:

Use calculated dimension:

if(Match(REGION_NAME,'AMS', 'EMEA', 'APJ'),'Y','N')

Regards

Aviral Nag

Re: How to make a field based on a condition

Sun, 10 Aug 2014 17:39:42 GMT

This was exactly what I needed thank you