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

[Rnc2005]

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 

[pradosh_thakur]

Please add some sample data to look at and give you a concrete answer

[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 · Accepted solution]

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

[Rnc2005]

I will try this now. Thank you!