topic Re: Set analysis to neglect few dimensions and include others in QlikView

Set analysis to neglect few dimensions and include others

Anonymous — Tue, 19 Mar 2013 21:51:50 GMT

Hi All,

I am trying to compare my firm level sales with the drill down/selected dimensions.

Dimensions I have :

1. Date

2. Product_Category

3. Product Name

Expressions:

SUM(Sales).

Here I want to just include only date dimension when i am selecting entire firm level sales and I want to exclude product_category and product dimensions.

I tired this but is not behaving right..

SUM({$<Date>}Sales) . Can you suggest me correct set analysis expression?

Thanks

Dasu.G

Re: Set analysis to neglect few dimensions and include others

Tue, 19 Mar 2013 22:36:06 GMT

Try with this:

SUM({< Product_Category=, Product_Name= >}Sales)

Regards,

Ricardo

Re: Set analysis to neglect few dimensions and include others

Tue, 19 Mar 2013 23:44:33 GMT

If you want to ignore the dimension and not the selection then you want to use the TOTAL keyword, e.g., sum(total<Date> Sales)

Re: Set analysis to neglect few dimensions and include others

MayilVahanan — Wed, 20 Mar 2013 00:25:03 GMT

Please refer this doc. http://community.qlik.com/docs/DOC-1334

Hope it helps lot

Re: Set analysis to neglect few dimensions and include others

udit_kumar_sana — Wed, 20 Mar 2013 04:19:01 GMT

Hi,

You can try below expression:

=if(GetSelectedCount(firm) = 0,

sum({<Product_category=,Product_name=>}Sales),sum(sales))

Regards,

Udit

Re: Set analysis to neglect few dimensions and include others

jagan — Wed, 20 Mar 2013 06:07:40 GMT

Hi,

Try this

=SUM(Total<Date> Sales)

Hope this helps you.

Regards,

Jagan.

Re: Set analysis to neglect few dimensions and include others

Thu, 15 Oct 2015 19:28:38 GMT

Thank's to you Jagan, I was able to do something, after a few hours, I thought was impossible:

Count( TOTAL <FieldMonth> Distinct{$<SiteField={'147'}>} Order#)

Super useful to know how to add-on to a Set Operator!

Thank you!