Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Robin666
Contributor
Contributor

Filter for Results from Expression

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

Labels (2)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.