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: 
Naps_230
Creator
Creator

Need some urgent help below code

Test:

LOAD * Inline [

ID , REPORT_WEEK, DATE, VALUE

1 , '2023-12 4Week', '2023-12-04', 87

2 , '2023-12 3Week', '2023-12-03', 12

3 , '2023-09 2Week', '2023-09-02', 50

4 , '2023-08 4Week', '2023-08-04', 34

];


i 'have data set like above , my requirement in qliksense is
create bar chart with id and value show chart value by default it should take maximum report week value dynamically, other data should show best selection on report week column value

how to do qlik chart expression level

Labels (2)
3 Replies
JonnyPoole
Former Employee
Former Employee

In the sample there is only 1 week per ID.  If you show a bar for each ID, do you want the max across all weeks regardless of ID? Because then the max value would be the same for all IDs. 

Or, does your data have multiple values for the same week per ID?

=Max( Aggr( Sum( Value), REPORT_WEEK, ID) )

... creates an array of summed values for each unique combination of week/id, then take the max of those values per ID

Or, does your data have one value per week per ID?  

=Max( Value )  

Naps_230
Creator
Creator
Author

Max( Aggr( Sum( Value), REPORT_WEEK, ID) ) VALUE Is coming " 12/30/1899" , it's not working

JonnyPoole
Former Employee
Former Employee

Then there is something you are not telling me.  I loaded your sample and tested and it works as I hoped it should:

 

JonnyPoole_0-1709909229517.png

Granted there isn't enough variability in the data to show what it does, but I was awaiting an answer to my previous question about the data variability before adding more data to the sample.