Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bvssudhakar
Contributor II

Error in Calculated Dimension

Hi

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

11 Replies
krishna_2644
Valued Contributor III

Re: Error in Calculated Dimension

What is vFitlerStates?


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


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

Digvijay_Singh
Honored Contributor III

Re: Error in Calculated Dimension

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

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

Re: Error in Calculated Dimension

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

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

bvssudhakar
Contributor II

Re: Error in Calculated Dimension

Thank you Marco Wedel

bvssudhakar
Contributor II

Re: Error in Calculated Dimension

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

bvssudhakar
Contributor II

Re: Error in Calculated Dimension

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

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);

QlikCommunity_Thread_294299_Pic1.JPG

QlikCommunity_Thread_294299_Pic2.JPG

QlikCommunity_Thread_294299_Pic3.JPG

QlikCommunity_Thread_294299_Pic4.JPG

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

QlikCommunity_Thread_294990_Pic1.JPG

QlikCommunity_Thread_294990_Pic2.JPG

QlikCommunity_Thread_294299_Pic6.JPG

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

QlikCommunity_Thread_294299_Pic5.JPG

QlikCommunity_Thread_294299_Pic7.JPG

hope this helps

regards

Marco

bvssudhakar
Contributor II

Re: Error in Calculated Dimension

Hi Marco

Thank you very much