topic Re: calculated dimesnion in QlikView

calculated dimesnion

manoranjan_d — Thu, 16 Jun 2016 09:05:12 GMT

Hi,

I have a field of passfailflag,

I want to create chart for the fail, so in the dimension how can i create calculated dimension for fail.

sunny_talwar — Thu, 16 Jun 2016 09:08:04 GMT

I think its better to use set analysis in your chart. May be like this:

{<passfailflag = {'fail'}>}

or if you still want to use dimension, you can try this:

If(passfailfalg = 'fail', passfailflag)

UPDATE: Just made sure to check 'Suppress When Value Is Null' option on the dimensions tab if you plan to use the calculated dimensions

Anonymous — Thu, 16 Jun 2016 09:14:05 GMT

Create a dimension as :

=if(passfailflag = 'fail' , 'Fail' , Null())

and uncheck the suppress null values checkbox .

manoranjan_d — Thu, 16 Jun 2016 09:16:52 GMT

{<passfailflag = {'fail'}>} its showing garbage error, will that set analysis will work?

sunny_talwar — Thu, 16 Jun 2016 09:18:37 GMT

Using that alone will not work, it needs to be added to you current expression's set analysis. What is the current expression/s you are using?

manoranjan_d — Thu, 16 Jun 2016 09:19:01 GMT

garbage after expression "='

sunny_talwar — Thu, 16 Jun 2016 09:36:17 GMT

You are getting this for the set analysis or the dimensions?