topic Re: Disable certain selection in QlikView

Disable certain selection

spcon2016 — Fri, 29 Sep 2017 13:22:36 GMT

Hello Community,

I'm trying to create a pie-chart, which disregards a certain selection. I have two list-boxes (customers and products) and in the middle of all a pie-chart. This one should only be modified by the customers-selection, not by the products-selection.

How I'm able to do that?

Here is the expression of pie-chart:

FABS(SUM (SALES)) / FABS(SUM(TOTAL SALES))

I thought abou Set Analysis, but how I could achieve what I need? Where to implement? Many questions and many gaps in my mind.

Best regards

K.K

Re: Disable certain selection

felipedl — Fri, 29 Sep 2017 13:24:34 GMT

Hi Kerim,

Use set analysis for this,

something like:

FABS(SUM ({<Products>}SALES)) / FABS(SUM({<Products>}TOTAL SALES))

This will not consider the selections made on the Products listbox, if I understood correctly, that's what you want to disconsider.

Felipe.

Re: Disable certain selection

prat1507 — Fri, 29 Sep 2017 13:24:39 GMT

Use

FABS(SUM ({<PRODUCT=>}SALES)) / FABS(SUM({<PRODUCT=>}TOTAL SALES))

Re: Disable certain selection

krishnacbe — Fri, 29 Sep 2017 13:25:09 GMT

Try below expression to exclude Products selection FABS(SUM ({}SALES)) / FABS(SUM({}TOTAL SALES))

Re: Disable certain selection

krishnacbe — Fri, 29 Sep 2017 13:26:02 GMT

Sorry Typo FABS(SUM ({}SALES)) / FABS(SUM({}TOTAL SALES))

Re: Disable certain selection

krishnacbe — Fri, 29 Sep 2017 13:26:43 GMT

FABS(SUM ({ PRODUCT= }SALES)) / FABS(SUM({PRODUCT= }TOTAL SALES))