Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Apply dimension restriction on a set analysis


I am trying to implement a dashboard showing users access statistics.

More specifically, I created a graph

- dimension : months of the year,

- expression: number of users who connected more than 20 times.

I have tried to implement it with this expression:

Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)

The issue is that the dimension is applied to the UserID only, not to the session count.

So in reallity my expression calculates the number of sessions irrespective of the months.

If I put a filter on a specific month, then the value shown is correct. Without filter, the values are wrong.

Anyone can help here to get the expression right?



3 Replies
Valued Contributor II

Re: Apply dimension restriction on a set analysis

Do you have a Month and Year field in your calendar??

This expression will make the count grouping by the field you choose, I´ve written MonthYear in the example

aggr(Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID), MonthYear)

Hope this helps

Not applicable

Re: Apply dimension restriction on a set analysis

Hi José

I do have a dimension called "YearMonth" in my calendar, and that's the one I use for my graph.

When I try applying your recommandation, the outcome is exactly the same, count of UserID is split based on the dimension (month), but the count for session start for each user is over the whole period in my calendar, not split by month also.

If I select one month only in the graph, then the session count will be restricted to that month only and the result displayed will be correct... but only one month is displayed, not the whole calendar :-(

Any other idea?



Valued Contributor II

Re: Apply dimension restriction on a set analysis

I think you must to use filters in blank to discard that filters, then, when you select a month, month filter will be discarded so that must show you the result for all your periods

Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)Count({<UserID={"=Count([Session Start])>20"},Month=, MonthYear=>} DISTINCT UserID)



Community Browser