Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
Will you please elaborate the total() and only() and exists() along with real time scenarios.
Help me out in this.
Thanks in advance!!
R'gs
Satish
Only(Field) is the same thing as Field - the difference is, that with Only() you can use set analysis.This is usually used for mapping dimensions.
Exists() is used within the script and is the equivalent of where FieldA = FieldB while FieldB is coming from a different table. This is very helpful if you want to achieve an optimized load (much faster!).
Total() does not exist. There is, however, a total qualifier within set analysis. The total indicates, e.g. in a chart, that the total of the aggregation will be displayed, irrespective of the dimensions. Without the total qualifier, the set analysis expression will evalutate for each dimension value respectively.
Hi Satish,
Please can you try using the help options in QlikView and the search on the Community pages and you will find many posts and examples on these topics.
If you still have further questions, then post more specific questions rather than just asking ' Please tell me about xxxxx'.
There are more general guidelines on using the Community here