Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikandlearn
Contributor III
Contributor III

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

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.

3 Replies
jwjackso
Specialist III
Specialist III

Try

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

Qlikandlearn
Contributor III
Contributor III
Author

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.