Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
notarolap
Contributor
Contributor

Set Filter on Formula Expression

Hi everbody,

I'm pretty new to Qlik and I'm trying to filter the expression below by a field called "Plnt".

I will need this expression only for Plnt = 3900 but I just can't get it.

((sum(if([Data Ext.]=Today(),([LDM (Lung)]*[Order Quantity])))) / (max(aggr(Sum([LDM (Lung)]*[Order Quantity]),[Data Ext.]))))

Could you please help me?

Thanks a lot in advance!!

Nicolas

Labels (2)
1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III

You would need something like this.

...{<[PInt]={'3100'}>}..

 

You may find the link below valuable.

Set modifiers 

View solution in original post

2 Replies
JustinDallas
Specialist III
Specialist III

You would need something like this.

...{<[PInt]={'3100'}>}..

 

You may find the link below valuable.

Set modifiers 

notarolap
Contributor
Contributor
Author

Thanks for you reply!

How can I construct the whole expression? 

Where do I have to put this {<[PInt]={'3100'}>} ?

((sum(if([Data Ext.]=Today(),([LDM (Lung)]*[Order Quantity])))) / (max(aggr(Sum([LDM (Lung)]*[Order Quantity]),[Data Ext.]))))