Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Evgen_Belov
Contributor
Contributor

How to calculate in Table (straight table)?

Hello!

One (may be stipud) question.

I calculate unique users rolling one year (last 365 days).

This expression: Count({<MyMonth={">=$(=max(MyMonth)-365)<=$(=max(MyMonth))"}>}DISTINCT UserID).

This expression good works in KPI object, when I use MyMonth filter.

I need create straight table: rows (dimension) - MyMonth, one column - unique "last-365" users. But when I use this expression on measure, it calculates wrong (calculates users only 1 month).

Where is my stupid mistake?

Labels (2)
0 Replies