Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Try

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Digital Support
Digital Support

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.