topic Error in Calculated Dimension in QlikView

Error in Calculated Dimension

bvssudhakar — Fri, 16 Mar 2018 11:58:45 GMT

I am getting error when i am trying to write calculated dimension in my chart properties >>> Dimensions

This is the dimension:

=aggr(only({$(vFitlerStates)}OrderID), OrderID)

But for remaining people it is working, only for me it's not working can you guys please help me out from this

Note: All People are working on same thing

Re: Error in Calculated Dimension

Qrishna — Sat, 17 Mar 2018 07:23:31 GMT

What is vFitlerStates?

Usually if you use set expression ,it would be something like this:

=aggr(only({$( FieldName = {'$(vFitlerStates)')}OrderID), OrderID)

Re: Error in Calculated Dimension

Digvijay_Singh — Sun, 18 Mar 2018 15:10:29 GMT

May be missing '<>' in set expression, not sure though-

=aggr(only({<$(vFitlerStates)>}OrderID), OrderID)

Re: Error in Calculated Dimension

tamilarasu — Sun, 18 Mar 2018 15:39:30 GMT

Hi Sudhakar,

I think you are using alternate state. Is your alternate state name having any spaces? If so, try,

=aggr(only({[$(vFitlerStates)]}OrderID), OrderID)

Re: Error in Calculated Dimension

MarcoWedel — Sun, 18 Mar 2018 20:58:32 GMT

Is this question related to your thread

Passing a set of filters in qlikview

Maybe also helpful:

Passing a set of filters in qlikview

regards

Marco

Re: Error in Calculated Dimension

bvssudhakar — Mon, 19 Mar 2018 05:47:09 GMT

Thank you Marco Wedel

Re: Error in Calculated Dimension

bvssudhakar — Mon, 19 Mar 2018 08:46:11 GMT

Hi Macro,

https://community.qlik.com/thread/294299

In this link what ever you attached qvw file is not opening. It is showing error (failed to load)

I am using Desktop Edition

can you please share that file again, so that it will very useful for me

Thanks in advance

Sudhakar

Re: Error in Calculated Dimension

bvssudhakar — Mon, 19 Mar 2018 09:03:38 GMT

Hi Marco,

https://community.qlik.com/thread/294299

In this link what ever you attached qvw file is not opening. It is showing error (failed to load)

I am using Desktop Edition

can you please share that file again, so that it will very useful for me

Thanks in advance

Sudhakar

Re: Error in Calculated Dimension

MarcoWedel — Mon, 19 Mar 2018 22:10:00 GMT

Hi,

please find attached an example using the data included in your thread Passing a set of filters in qlikview

table1:
LOAD survey,
    [prod ctg],
    char,
    [char type],
    [rate 1],
    [rate 2],
    [rate 3],
    volume
FROM [https://community.qlik.com/thread/294525] (html, codepage is 1252, embedded labels, table is @1);

--------------------------------------------------------------------------------------------------------

=vSelSets&If(Len(GetCurrentSelections()),If(Len(vSelSets),'+')&'1<['&GetCurrentSelections(Chr(39)&'}, [',']={''',Chr(39)&','&Chr(39))&Chr(39)&'}>')

hope this helps

regards

Marco

Re: Error in Calculated Dimension

bvssudhakar — Tue, 20 Mar 2018 07:25:05 GMT

Hi Marco

Thank you very much

Re: Error in Calculated Dimension

MarcoWedel — Tue, 20 Mar 2018 23:16:45 GMT

You're welcome.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Error in Calculated Dimension

MarcoWedel — Wed, 21 Mar 2018 23:22:01 GMT

Did the proposed solutions answer your question?