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: 
Rnc2005
Contributor II
Contributor II

Data that's already calculated (measured) in the database

Is there a way to display data that's already calculated in the database and bypass measures? 

For example: 

Current users = 60,000 BUT there's a field in the data base that does the calculation of 'Active Users'= 2,000

I'd like to put the 'Year Month' of already calculated 'Active Users' in a chart...of course I have no issues doing this in a table but that's not fun! 

Hope this makes sense 🙂

#NewToQlikSense #StillTakingTraining 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You will always need a measure, even if it is just sum([Active Users])

talk is cheap, supply exceeds demand

View solution in original post

4 Replies
pradosh_thakur
Master II
Master II

Please add some sample data to look at and give you a concrete answer
Learning never stops.
OmarBenSalem

can u flag the active users?

In the table of the users, add a new field (FlagActive) with value 1 for every active user

Then, create aur chart with ur monthYear dimension and as a measure

count(distinct {<FlagActive={1}>} User)

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You will always need a measure, even if it is just sum([Active Users])

talk is cheap, supply exceeds demand
Rnc2005
Contributor II
Contributor II
Author

I will try this now. Thank you!