Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wcamargo
Contributor III
Contributor III

Filtering a column per a maximum value to show on histogram

Hi all,

 

I want to show on the histogram only the values from the 2nd major week.

Example: I have this table with "Week" and "feature_value". And week "6" is the 2nd major week.

Week feature_value
3 10,1
4 10,5
5 10,7
5 10,3
6 11,1
6 10,7
7 10,3

 

Basically What I want is this:

Week feature_value
6 11,1
6 10,7

 

 

I succeed doing it in qliksense table with this formula: 

'=Num(Aggr(distinct IF(max(Week,2),feature_value),feature_value))'

 

But, when I use it on the histogram it appears "The chart is not displayed because it contains only undefined values."

 

See below the error:

wcamargo_0-1676226636459.png

 

Does anybody know how to solve it?

Labels (4)
0 Replies