topic Qv_function in QlikView

Qv_function

Tue, 20 Jan 2015 21:13:18 GMT

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

Re: Qv_function

simondachstr — Tue, 20 Jan 2015 21:19:38 GMT

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.

Re: Qv_function

Colin-Albert — Tue, 20 Jan 2015 21:34:43 GMT

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