Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pthai
Contributor III
Contributor III

Dimension in Set analyst

Hello everyone,

I need help for an expression.

Original measure for max ID

IDDataCounting
111AA0
222BB1
333CC0

 

Counting = Count({$<ID={$(=Max(ID)-111)}>}DISTINCT ID)

I want to display for each ID value as 

IDDataCounting
111AA1
222BB1
333CC0

Counting = Count({$<ID={$(=(ID)-111)}>}DISTINCT ID)

But, it seem like not work. All counting data is 0. Anyone can help me?

0 Replies