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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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