Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
http://community.qlik.com/message/645009#645009
just check this...it may help you...
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!
thanks ruben,
could you please explain with some other examples if possible.
regards,
Barathiraja
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
great
thanks a lot ruben
Hi Barathiraja,
Did you achieve this ?
Thanks