topic Re: Converting the chart from Summary level to data level (time period level) in QlikView

Converting the chart from Summary level to data level (time period level)

Qlikandlearn — Wed, 25 Nov 2020 16:16:04 GMT

Please help here with the right function/Condition..

Screenshot 1:

Time \| Period	8/30	09/06	09/13	09/20	09/27	10/04	10/11
11/20	$11	$13	$34	$67	$56	$56	$56
Total	$11	$13	$34	$67	$56	$56	$56

Here AsOf is dates from 8/30/2020 - 10/11/2020

Screenshot 2:

Nov 2020
Order	Desc	Location	Amount	total qty	Insurance	number	purchase
30006789	Indexer	Zc-1234	$56	$28	$66	Rt34	$45

I’ve a requirement to show only the Max time period value from the Screenshot 1(Marked as Red) in the screenshot 2, but when I use the below expression in Properties for screenshot 2, it’s showing the total sum value (Marked as Green), find the total from the screenshot 1.

=sum({<Period = >}Qty *[ Price])

Can you help here with the right function, how can I show only the Max(AsOf) value in screenshot 2?, in other words, I’ve to modify the 2nd object at time period level from Summary level.

Thanks in Advance.

Re: Converting the chart from Summary level to data level (time period level)

jwjackso — Sat, 10 Oct 2020 16:35:33 GMT

Try

=sum({<AsOf = {"=$(=Max({1}AsOf))"}>}Res.Qty *[Moving Avg Price])

Re: Converting the chart from Summary level to data level (time period level)

Qlikandlearn — Mon, 12 Oct 2020 12:56:51 GMT

Thanks for your response, it's throwing syntax error at Price.

Re: Converting the chart from Summary level to data level (time period level)

Brett_Bleess — Tue, 27 Oct 2020 14:14:00 GMT

You will likely need to attach sample QVW to get further assistance, this is the best thing to do in these types of posts so folks can look at the data model and all chart properties etc. to be sure you get the correct answer the first time through...

You can search in the Design Blog area to see if anything there may help you with things:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Best I can offer to try to help you further.

Regards,
Brett