Filter for Results from Expression

[Robin666]

Hey,

im new to Qlik and we have some problems.

In our pivot table we are calculating the "Win_%" with this expression:

=if(Typ= 4,

if(Product='G',
(sum(HSP_Positionen)/sum(Positionssumme_Netto/1.19))*-1,
(sum(HSP_Positionen)/sum(Positionssumme_Netto/1.19))*1),

if(Product='G',
(sum(HSP_Position)/sum(Position_Netto))*-1,
(sum(HSP_Position)/sum(Position_Netto))*1))

Pivot table

Now we want to filter the view for either "Win_%" bigger than 30% or smaller than 30%.

Is it possible to implement a multibox or button with the two funcions?

I thought about something like --> if('Win_%'<='0,3',Jahr) and the opposite.

It worked somehow when i used a existing Field Name instead of the Expression 'Win_%'

Does QlikView support to use a Expression as Condition, or are there other ways or best practices for this case.

Best regards

[Brett_Bleess]

Have a look around on the Design Blog area, you might find something there that relates:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There is a search dialog on that page, just start typing in and it will return a list of matches...  Hopefully you may be able to find something that helps there.

Regards,
Brett