Hello Experts,
I am working on a assignment where have to convert Tableau Level of details (LOD) expression to QlikSense.
Would like to know what is the best way to get these expression converted. Below is an example for few expressions in Tableau
1. {Fixed dime1, dim2 : Sum(Sales)/Count(trades)}
2. Exclude(dim : CountD(Dim)}
Currently have used AGGR() and sum() to achieve fixed expression while for Exclude have used Count(Total distinct Dim) - this is providing same numbers but would like to know best possible way to achieve this.
Also, have to handle various variables as part of calculations, would like to hear best way on handling multiple variable in an expression
Thanks,
Punit