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?
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!
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