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: 
CharanY28
Contributor
Contributor

Measure Issue

I have one scenario, I have Requirement like when sum(total spend) is > 0, show Lds, ens etc. 

I have created slider for it , created vSpentThreshold variable which has value 0 and Given 0 to 50,000 as min and max  with 10,000 as step, when sum(total spend) is > 0, it should remove those institute names in pivot chart which have spend = 0 it removes Lds and other measures also
For this I created Lds measure as below:

NUM( Count({< [Fact Type]={'Ld'}, [Institution Name]={"=If($(vSpentThreshold) = 0, 1, Sum([total spend]) > $(vSpentThreshold))"} >} DISTINCT [Ld ID]), '#,##0' ) When I'm doing this it's removing "-" institutes even when slider at 0

I have used below measure also not working

NUM( Count({< [Fact Type]={'Ld'}, [Institution Name]={"=If($(vSpentThreshold) = 0, 1, Sum([total spend]) > $(vSpentThreshold)) OR IsNull([Institution Name]) OR [Institution Name] = '-'"} >} DISTINCT [Ld ID]), '#,##0' )

WHEN i give Count({< [Fact Type]={'Ld'}>} DISTINCT [Ld ID]), It'a giving "-" included count also

I enabled Show null values also for Institution name in Dimension

Could anyone please help me on this

Labels (2)
1 Reply
Chanty4u
MVP
MVP

Try this 

NUM(

    Count({

        < 

            [Fact Type] = {'Ld'}, 

            [Institution Name] = {"=Sum([total spend]) > $(vSpentThreshold)"} 

        > 

    } DISTINCT [Ld ID]), '#,##0'

)