Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
spcon2016
Partner
Partner

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
Specialist
Specialist

Use

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

View solution in original post

5 Replies
felipedl
Partner
Partner

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
Specialist
Specialist

Use

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

View solution in original post

krishnacbe
Partner
Partner

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

krishnacbe
Partner
Partner

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

krishnacbe
Partner
Partner

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