topic Re: All Qualifier in QlikView

All Qualifier

gardan — Mon, 20 May 2013 20:15:45 GMT

I'm currently using QV10 and will be upgrading to QV11 sometime this summer.

currently I'm trying to write an expression on the front end. I'd like the expression to show the sum of costs for the previous year and ignore all selections, but still obey two or more chart dimensions. Normaly I'd use the ALL qualifier for this, but it seems the ALL qualifer is being phased out. It does not work any longer with more than one selection like below. I know the ALL was replaced with {1} but i cant seem to figure out how to show all costs while still respecting only the fields I specify.

Sum ({<FlagPrevFYear = {1}>}ALL <TransType,FlagPrevFYear> Cost)

Re: All Qualifier

Miguel_Angel_Baeyens — Mon, 20 May 2013 21:17:31 GMT

Hi,

The ALL is now a combination of {1} and TOTAL, so the expression should look like

Sum ({1 <FlagPrevFYear = {1}>} TOTAL <TransType,FlagPrevFYear> Cost)

Hope that helps.

Migeul

Re: All Qualifier

gardan — Tue, 21 May 2013 12:22:35 GMT

thanks, that seemed to help.

my final expression ended up looking like this:

Sum

({1<FlagPrevFYear = {1}, FiscalPeriodName = P(FiscalPeriodName)>} TOTAL<ABCTransType,FlagPrevFYear, FiscalPeriodName> Quantity)

I wanted to let the user be able to select the FiscalPeriodName field but not any others. it seems to work ok.

thanks!

Re: All Qualifier

gardan — Tue, 21 May 2013 12:23:29 GMT

thanks, that seemed to help.

my final expression ended up looking like this:

Sum

({1<FlagPrevFYear = {1}

, FiscalPeriodName = P(FiscalPeriodName)>} TOTAL<ABCTransType,FlagPrevFYear, FiscalPeriodName> Quantity)

I wanted to let the user be able to select the FiscalPeriodName field but not any others. it seems to work ok.

thanks!