Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
naveen_kunuru
Partner - Contributor
Partner - Contributor

How to write greater than one expression

Hello All,

          

            I need to write a expression to display only those prices where count of distinct prices are greater than 1 for a materials and plants combination


so i wrote this expression


Aggr(If(Count({<SCOPE={'Yes'}, VALIDTO ={">$(=Date(today(),'DD-MM-YYYY'))"}>} DISTINCT PRICE_MAT) > 1, sum({<SCOPE={'Yes'}, VALIDTO ={">$(=Date(today(),'DD-MM-YYYY'))"}>}DISTINCT PRICE_MAT)),[MATERIAL CODE],[PLANT CODE])


so what i got is this()

Capture1.PNG

The Above expression is picking only one supplier even though it is having 6 distinct supplier ,so what should i need to change in my expression to get display all the supplier for that material plant combination

Capture.PNG

Thanks

1 Reply
sunny_talwar

Create two profiles to ask the same question? Look for my response here

How to write a greater than expression