Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matheus_silva
Contributor

Ignore a filter, but not totaly!!!

Hi guys.

  Attached there is a example what i need, let me explain:

When i filter the ID_PRODUCT 88776, i see who much my company sold that product, and the chart 2 i have the sell the all product witch have same ID_SIMILIR, (i mean, when i put a product X in offer, consequently i put the product Y too)  but in the chart 3, i dont wanna sum just values about that product in filter, i want sum all value about that GROUP...but i dont wanna show aaall GROUP, just GROUP reference ID_PRODUCT_OFFER, but char 3 sum all values reference the GROUP...

In the other words, chart 3 must be : I LOVE BEER : 7,81

I used set analysis, and i get so closed, but i cant show just GROUP i need.

Somebody help me?

1 Solution

Accepted Solutions

Re: Ignore a filter, but not totaly!!!

Hi,

Try below expression.

SUM({<GROUP = p(GROUP),ID_PRODUCT_OFFER=>}VALUES)

Regards,

Kaushik Solanki

2 Replies

Re: Ignore a filter, but not totaly!!!

Hi,

Try below expression.

SUM({<GROUP = p(GROUP),ID_PRODUCT_OFFER=>}VALUES)

Regards,

Kaushik Solanki

matheus_silva
Contributor

Re: Ignore a filter, but not totaly!!!

Thank you man!!!
But i dont know why, in my main file dont worked....=/
the expression sum all witch group, but just the product in filter(char 2)....

But thank you anyway!!!

Community Browser