Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qv_function

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

2 Replies
simondachstr
Luminary Alumni
Luminary Alumni

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.

Colin-Albert

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

Qlik Community Tip: Posting Successful Discussion Threads

http://community.qlik.com/docs/DOC-2380#comment-3393