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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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'

)