Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 )
Max( Aggr( Sum( Value), REPORT_WEEK, ID) ) VALUE Is coming " 12/30/1899" , it's not working
Then there is something you are not telling me. I loaded your sample and tested and it works as I hoped it should:
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.