topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

Mon, 09 Jun 2014 12:31:23 GMT

Hi ,

Iam totally fresh to functions .

THANKS for ur Reply Guys

Actually i have dimensions called BRAND which has many different brands and under each brand ther are many branches depending on the cities , so my teacher asked me to write such an expression when i clikc on perticular branch type , it should show to which brand and which city it is belonged , I HOPE SO IAM CLEAR

Thanks in advance

Re: SET ANALYSIS

Mon, 09 Jun 2014 12:33:44 GMT

This may be a good place for you to start

Set Analysis: syntaxes, examples

Re: SET ANALYSIS

alexandros17 — Mon, 09 Jun 2014 12:35:26 GMT

this is an example:

Sum({$ <brand={'Ferrari'}, brand_type={'CAR'}, city={'NEW YORK'}, customers={'DUFFY'}>} Sales)

let me know

Re: SET ANALYSIS

Mon, 09 Jun 2014 12:36:34 GMT

What are you trying to accomplish with your selection?

The default set analysis is the current selection.

Examples:

sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$1} Sales )
returns sales for the previous selection.

sum( {$_2} Sales )
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as

dimension, each product will get a different value.

sum( {1} Total Sales )
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).

sum( {BM01} Sales )
returns sales for the bookmark BM01.

sum( {MyBookMark} Sales )
returns sales for the bookmark MyBookMark.

sum({Server\BM01} Sales)
returns the sales for the server bookmark BM01.

sum({Document\MyBookmark}Sales)
returns the sales for the document bookmark MyBookmark.

These examples are from the QV help files.

Re: SET ANALYSIS

ashfaq_haseeb — Mon, 09 Jun 2014 12:38:15 GMT

Hi start with this.

Regards

ASHFAQ

Re: SET ANALYSIS

anbu1984 — Mon, 09 Jun 2014 12:38:16 GMT

Check this