topic Re: displaying the max date available from the data in QlikView

displaying the max date available from the data

Anonymous — Fri, 20 Jan 2017 05:09:28 GMT

I need to display the maximum date from the spreadsheet at any given point in time and the sum of the mins for that month for a particular service id

Dimensions to be max(PERIOD_NAME) and SRV_ID while the expression is simple sum(CUSTOMER_IMPACT_MINS).

but max(PERIOD_NAME) shows an error for calculated dimension.

not sure what is going wrong as when i put this in a text box it works fine but shows error when i put it in a chart

Sample data attached.

Re: displaying the max date available from the data

girirajsinh — Fri, 20 Jan 2017 05:43:20 GMT

What are your chart expression and dimensions?

Re: displaying the max date available from the data

Anonymous — Fri, 20 Jan 2017 05:53:58 GMT

Expression is sum(CUSTOMER_IMPACT_MINS).

Dimensions need to be SRV_Id and max(PEriod Name)

Re: displaying the max date available from the data

girirajsinh — Fri, 20 Jan 2017 06:09:24 GMT

try expression

sum({<PERIOD_NAME={"=max(PERIOD_NAME)"} >} CUSTOMER_IMPACT_MINS)

Re: displaying the max date available from the data

Anil_Babu_Samineni — Fri, 20 Jan 2017 06:11:27 GMT

You may try

sum({<[PEriod Name] = {''$(=Max([PEriod Name]))"}>}CUSTOMER_IMPACT_MINS)

Updated, Tested

Sum({<PERIOD_NAME = {'$(=Max(PERIOD_NAME))'}>}CUSTOMER_IMPACT_MINS)

Re: displaying the max date available from the data

Fri, 20 Jan 2017 06:15:30 GMT

Create a variable for max period using date#. then try:

sum({<PERIOD_NAME={"=$(vEndField)"} >} CUSTOMER_IMPACT_MINS)

Good Luck,

Pravesh

Re: displaying the max date available from the data

girirajsinh — Fri, 20 Jan 2017 06:53:37 GMT

Yes as Anil Babu spotted out, I missd the expansion $ here. But this gives your always last period, as you always have periods till Dec. So if you intend to show max across the period and wann a show that period, use Max in expression and may be period in dimension. and Uncheck "show zero values" from presentation tab, in case wannn a show all SRV_ID

sum({<PERIOD_NAME={"$(=MAX(PERIOD_NAME))"}>} CUSTOMER_IMPACT_MINS)