topic Re: Exclude Selections in QlikView

Exclude Selections

rido1421 — Thu, 12 Feb 2015 10:30:56 GMT

Hi There

I have a field [CurrentFiscalMonth]

the value for this field is the current fiscal month so right now it is 5

I would like to use this value and keep it constant regardless of any selections made

When selecting future months this value becomes in valid which is correct.

I would just like to get a function to keep it regardless of any selections

eg. Sum({1<FiscalMOnth={5}>}Forecast)

I want to do this but without the Sum...

if there anything like below... that i could use in an expression.

eg 1< {[CurrentFiscalMonth]}>

Thanks.

rubenmarin — Thu, 12 Feb 2015 10:34:14 GMT

Hi Rido, there is an Only() function:

Only({1<FiscalMOnth={5}>}Forecast)

rido1421 — Thu, 12 Feb 2015 10:38:56 GMT

Hi Ruben

It doesnt seem to be working

vCurrentFiscalMonth= Max(CfiscalMonth)

Only({1<CfiscalMonth={$(vCurrentFiscalMonth)}>}CfiscalMonth)

IT still changes when selecting a future month

rubenmarin — Thu, 12 Feb 2015 10:41:27 GMT

Hi Rido, you're filtering CfiscalMonth with the value of vCurrentFiscalMonth.

If you want vCurrentFiscalMonth to store alwallys the max CfiscalMonth you can use:

vCurrentFiscalMonth= Max({1} CfiscalMonth)

rido1421 — Thu, 12 Feb 2015 10:52:21 GMT

Thanks Ruben that works