Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Digital Support
Digital Support

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.