Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional expression- 2 ifs and aggr

Hi Community,

I've been struggling with this for quit some time now and I can really use your help..

I need to perform the following calculation that is based on several ifs and functions.

The granularity of the data is by AspectId and ReviewId and I need to return the AspectName id the bottom 2 conditions apply.

1- If the below calculation is smaller than 0.5 than continue to calculation #2

Aggr(

(Sum( Aggr( max( {<PostQuarter= {'20143'}>} Sentiment),AspectId, ReviewId) )

/Count( Aggr( Count(distinct {<PostQuarter= {'20143'}>} AspectId) ,AspectId ,ReviewId) ))

,[Aspect Name])<0.5

2- Return the AspectName when Rank = 1

rank( Aggr( Count( Aggr(Count(distinct {<PostQuarter= {'20143'}>} AspectId) ,AspectId ,ReviewId) ),[Aspect Name]))=1,[Aspect Name])

Thanks for your help!

-Hila.

1 Reply
MK_QSL
MVP
MVP

Can you provide some sample data please to work?