topic Re: Need some urgent help below code in App Development

Need some urgent help below code

Naps_230 — Fri, 15 Nov 2024 21:02:13 GMT

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

Re: Need some urgent help below code

JonnyPoole — Fri, 08 Mar 2024 14:06:39 GMT

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 )

Re: Need some urgent help below code

Naps_230 — Fri, 08 Mar 2024 14:35:16 GMT

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

Re: Need some urgent help below code

JonnyPoole — Fri, 08 Mar 2024 14:47:56 GMT

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.