Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
johnso2080
Contributor
Contributor

Expression for 'Closing' Figures

Hi, I'm trying to create an expression that gives me the sum of stock from only the LAST date of the current selection...

A basic equivalent of the tables used are...

StockHistory:

Product ID

Date

Stock Level

Products:

Product ID

Category 1

Category 2

Category 3

Calendar:

Date

Week

Month

I need, for any selections that may occur, the SUM([Stock Level]) only for the last date in the selection or the dimension in a chart. For example we might want to see a table with dimensions [Week] and [Category 3] and we would want to see the sum of stock for each category on the last day of each week shown in the table.

Also, the dimensions are not set in the tables/charts themselves, they are dynamic based on user selections/variables.

Hope that's clear! Any help much appreciated!

Darren

12 Replies
johnso2080
Contributor
Contributor
Author

Thanks Joe, it seems like I might have to go with this approach...

Not applicable

no worries, glad to help

johnso2080
Contributor
Contributor
Author

Hi, are there any other ideas on this one..? 😕

Thanks!