Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

spcon2016
New Contributor

Disable certain selection

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.

Beautiful_easy_understandable_visualization.JPG

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

1 Solution

Accepted Solutions
prat1507
Valued Contributor

Re: Disable certain selection

Use

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

5 Replies
felipedl
Valued Contributor III

Re: Disable certain selection

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.

prat1507
Valued Contributor

Re: Disable certain selection

Use

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

krishnacbe
Valued Contributor III

Re: Disable certain selection

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

krishnacbe
Valued Contributor III

Re: Disable certain selection

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

krishnacbe
Valued Contributor III

Re: Disable certain selection

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

Community Browser