First of all, I want to thak you for your answer and for the book.
If it's possible and you have any free time, I can you explain me th answer for my second question.
I know how to solve this task in SQL-Server. The solution for this task looks like this:
Select Count(Users.Age) from dbo.Users
Group By (Age).
But in QV it's not working and I can't to find any good way for solving it!
What exactely is not working?
1) Start with loading in your data. Are you using a simple single table or a more complex data model?
There are free tutorials that get's you started with the basics:
There are also a lot of stuff here in the forum, but it may not easy to find, start with this if you are interested in data modelling:
Or even better, get a copy of a good book:
2) If you have successfully loaded your data in an appropriate model (a simple table may be enough to start), you can create chart objects.
Don't use any SQL syntax in chart objects, only QV functions allowed.
User Age as your dimension field, and an aggregation as expression:
(it's depending on your data model and requirements, what you need to use).
You can of course use SQL statements in your script, but this will lead to static answers to your business questions (i.e. answers are written in your data model).
The nice thing about the Qlik associative data model is that it's dynamic, responsive to user selections.
Not sure if you are way above this, but I would recommend that you attend the webinars or get a copy of 'QV11 for developers' which is highly recommended, to experience what Qlik is all about.