topic Re: Ignoring a dimension based on user selection in QlikView

Ignoring a dimension based on user selection

Tue, 02 Oct 2012 15:17:19 GMT

Hello:

I have a chart which I want the users selected date(s) to be ignored as I want to present all the dollar values totalled by year. I've attached a sample file.

My problem is that when calculating "Equity" the dollar value is correct for the user selected year but out for all the other years, even though my expression is coded to ignore the date selections. I can't figure out why the dollar value is only correct for the selected year?

Thx,

Re: Ignoring a dimension based on user selection

whiteline — Tue, 02 Oct 2012 15:58:20 GMT

Hi.

I've made some investiogations. The problem is with your if() expression.

You should use something like this:

if (Only({<[Fiscal Year]=,Month=, Quarter=>} Field) = 'Equity',...

otherwise it falls to else for every year excluded by selection.

Re: Ignoring a dimension based on user selection

Tue, 02 Oct 2012 16:02:13 GMT

Thanks so much, this board is awesome and your help is much appreciated!