calculated dimension in qliksense

[#1]

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

[#2]

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

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

[rubenmarin]

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!

[#4]

thanks ruben,

could you please explain with some other examples if possible.

regards,

Barathiraja

[rubenmarin]

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

[#6]

great

thanks a lot ruben

[saravanaprabhu]

Hi Barathiraja,

Did you achieve this ?

Thanks