topic Re: How to set analysis in this case?(Qlik Sense) in App Development

How to set analysis in this case?(Qlik Sense)

Anonymous — Fri, 13 Jan 2017 08:32:54 GMT

Hi all,

I have received a requirement of below:

I would like to set an analysis of summing all the sales quantity if the shop has the Product A

Result should be 2+1+7 =10

Best Regards,

Louis

MK_QSL — Fri, 13 Jan 2017 08:38:53 GMT

=SUM({<Product = p({1<Shop = {'S1'}>}Product)>}[Sales Quantity])

Anonymous — Fri, 13 Jan 2017 08:46:45 GMT

Hi Manish,

Thx for quick reply!

How about if there is not only one shop has Product A?

Result should be 2+1+7+3+5 =18

Sum the quantity of shop S1 and S2 because only these two shop have Product A

Best Regards,

Louis

MK_QSL — Fri, 13 Jan 2017 08:51:08 GMT

I didn't get your logic. Please explain..

MK_QSL — Fri, 13 Jan 2017 08:53:37 GMT

=SUM({<Shop = {'S1','S2'}>}[Sales Quantity])

Anonymous — Fri, 13 Jan 2017 08:55:09 GMT

Hi Manish,

I would like to sum all the quantity of those shops if those shops have the Product A.

In table above,

Shop S1 and S2 have the Product A, therefore sum all the quantity of these two shops.

Best Regards,

Louis

MK_QSL — Fri, 13 Jan 2017 08:58:55 GMT

=SUM({<Shop = p({1<Product = {'A'}>}Shop)>}[Sales Quantity])

Anonymous — Fri, 13 Jan 2017 09:19:58 GMT

Thx! It Works