topic Using an Input box to show comparitive period in QlikView

Using an Input box to show comparitive period

Fri, 26 Aug 2011 14:21:51 GMT

Hi,

I'm trying to use an input box to force a period (1 through 12) into an expression in order to show a comparitive period, regardless of what period is otherwise selected.

My Input Box Variable is called: PVar

The expression i'm attempting to use is:

Sum({$<[Period]={$(=Only([PVar]))}>}[Equivalent Units])

Any Idea what I'm doing wrong?

Using an Input box to show comparitive period

Fri, 26 Aug 2011 14:31:18 GMT

Hi,

When using a variable in set analysis you don't need to use the Only() function because the variable contains only one value, so the expression should be:

Sum({$<[Period]={$(PVar)}>} [Equivalent Units])

Regards!

Using an Input box to show comparitive period

Fri, 26 Aug 2011 14:42:33 GMT

Thank you Gabriela, Works perfectly.

Now I would like to add that expression to the below expression which shows our previous fiscal year (our fiscal years are in the 2010-2011 format).

Sum({$<[Fiscal Year]={"$(=Only((SubField([Fiscal Year],'-',1) - 1) & '-' & (SubField([Fiscal Year],'-',2) - 1) ))"}>} [Equivalent Units] )

Any help?