topic Re: Getting Error in Calculated Dimension in QlikView

Getting Error in Calculated Dimension

NavinReddy — Sun, 17 Apr 2016 18:01:22 GMT

Dear Experts,

The experssion im using its not working on pivot table

its giving "Error in Calculated Dimension "

=count(aggr(Only({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD), Metric))

Can some one help me where i am doing wrong

Any Suggestions

Best Regards,

Niranjan

Re: Getting Error in Calculated Dimension

sunny_talwar — Sun, 17 Apr 2016 18:03:34 GMT

Try this without the outer aggregation -> Count in your case:

Aggr(Only({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD), Metric)

and may be you need to use Count(Metric) as your expression.

Re: Getting Error in Calculated Dimension

swuehl — Sun, 17 Apr 2016 18:51:57 GMT

Maybe you can clarify what you want to achieve.

As far as I can see, the advanced aggregation expression will return at most a single distinct value across your Metric aggr dimension, 'R'.

So not sure why you want to use a (calculated) dimension at all here.

Or are you trying to mimic an expression that is only shown once in your pivot table?

In any case, it would be more than helpul if you describe the context you are using this expression / dimension in more detail (Other dimensions, expressions, relation and values of your fields you are using might be helpful, too).

Re: Getting Error in Calculated Dimension

NavinReddy — Sun, 17 Apr 2016 19:23:43 GMT

Hi Sunny & Stefan,

Thanks for your reply

i just want to display numbers and including percentage with 3moths of data

i have attached sample application please help me

pivot table im not able archive

Best regards,

Niranjan

Re: Getting Error in Calculated Dimension

swuehl — Sun, 17 Apr 2016 19:34:50 GMT

Which part is not working and what do you expect to see?

Re: Getting Error in Calculated Dimension

NavinReddy — Sun, 17 Apr 2016 19:45:23 GMT

Hi Stefan,

Top pivot table working fine but want to display 3months data including percentage

bottom table im able to display numbers & percentage but i just want to display top pivot table format

Best Regards,

Niranjan

Re: Getting Error in Calculated Dimension

NavinReddy — Sun, 17 Apr 2016 20:20:46 GMT

Hi Stefan,

please find the attachment revised application

i just want to merge both the above pivot information like bottom chart look like

please any way to do this

Best regards,

Niranjan

Re: Getting Error in Calculated Dimension

sunny_talwar — Sun, 17 Apr 2016 21:10:11 GMT

Niranjan -

It seems that you are able to achieve what you are looking for in the bottom table. Am I missing something? What exactly are you unable to achieve?

Re: Getting Error in Calculated Dimension

NavinReddy — Mon, 18 Apr 2016 10:05:37 GMT

Hi Sunny,

Good Morning,

for attached sample application i just want show numbers and Percentage in one pivot table

now i am displaying the information in two tables

Best Regards,

Niranjan

Re: Getting Error in Calculated Dimension

sunny_talwar — Mon, 18 Apr 2016 10:06:28 GMT

But isn't the buttom table has both of them?

Re: Getting Error in Calculated Dimension

NavinReddy — Tue, 19 Apr 2016 06:40:19 GMT

Hi Sunny,

Sorry for my late reply,

bottom chart have limited dimensions, top chart having all the expression and dimensions

not sure how to get percentage on the same chart

Thanks,

Niranjan

Re: Getting Error in Calculated Dimension

sunny_talwar — Tue, 19 Apr 2016 09:22:46 GMT

I am still not sure what you are looking for.

Are you concerned that TireStatus doesn't show last 4 options that are available above? but you are using an if statement in your dimension to get only those, isn't it?

=if((RAG_RATING_CD) = 'R','Tier1',if((RAG_RATING_CD) = 'A','Tier2',if((RAG_RATING_CD)= 'G','Tier3',if((RAG_RATING_CD)= 'NA','Data Not Available or Tier Limits Not Established'))))

What isn't working? Please can you highlight in the image?