Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

calculated dimension in qliksense

Hi experts,

i am new to qliksense. i want to know whether it is possible to create calculated dimension in qliksense?

if its possible, how to do?

regards,

Barathiraja

Tags (1)
6 Replies
Not applicable

Re: calculated dimension in qliksense

http://community.qlik.com/message/645009#645009

just check this...it may help you...

Re: calculated dimension in qliksense

Hi Barathiraja,

Yes, you can create calculated dimension, say you have a 'Dimension' field to simulate a ciclic group (The values of this field are the names of the fields you want to use as ciclic), in this case you click on 'Add column' in Dimensions tab and add [$(=MinString(Dimension))] as the calculated dimension.

Hope this helps!

Not applicable

Re: calculated dimension in qliksense

thanks ruben,

could you please explain with some other examples if possible.

regards,

Barathiraja

Re: calculated dimension in qliksense

In summary, are pretty similar as it was in QlikView (I didn't found any differences so far), you can use aggr, if, etc... it the same way:

aggr(If(Min(Level)<=3 and Report='BAL', Text([MainTitle]), Null()), [MainTitle]) --> will show all MainTitle with Level<=3 and Report=BAL

Limitations are (so far i know, maybe there is a workaround):

- You can't use conditional dimension

- You can't use calculated labels

Not applicable

Re: calculated dimension in qliksense

great

thanks a lot ruben

saravanaprabhu
New Contributor II

Re: calculated dimension in qliksense

Hi Barathiraja,

Did you achieve this ?

Thanks