Filter for Results from Expression

Robin666 — Sat, 16 Nov 2024 02:56:03 GMT

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

Re: Filter for Results from Expression

Brett_Bleess — Wed, 14 Aug 2019 19:24:54 GMT

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

topic Filter for Results from Expression in QlikView

Filter for Results from Expression

Re: Filter for Results from Expression