topic Re: Display Current Month Selected in QlikView

Display Current Month Selected

Anonymous — Mon, 01 Jul 2013 23:24:12 GMT

I have a line graph that displays all months selected and also a test box that should only display the amount for the most recent month selected. What is the expression that could make this work?

Here is what I have but it is pulling YTD not just the amount in the last month.

Sum({$<[acct month] = {$(=Max([acct month]))},[acct year] = {$(=Max([acct year]))} , [acct month] = >} [trans amt])

Re: Display Current Month Selected

Sokkorn — Tue, 02 Jul 2013 01:47:30 GMT

Hi,

Maybe you can consider this function:

GetFieldSelections (FieldName [, ValueSep [, MaxValues]]) -> Returns a string with the current selections in a field. ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

Regards,

Sokkorn

Re: Display Current Month Selected

jonathandienst — Tue, 02 Jul 2013 06:54:04 GMT

I suspect that the second assignment for [acct month] is overriding the first. Try

Sum({$<[acct month] = {$(=Max([acct month]))},[acct year] = {$(=Max([acct year]))}>} [trans amt])

This expression assumes that [acct month] is a numeric field with the month number.

Hope that helps

Jonathan

Re: Display Current Month Selected

Anonymous — Tue, 02 Jul 2013 16:26:02 GMT

That worked! Thank you!