Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Ignoring a dimension based on user selection

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,

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Ignoring a dimension based on user selection

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.

2 Replies
whiteline
Honored Contributor II

Re: Ignoring a dimension based on user selection

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.

Not applicable

Re: Ignoring a dimension based on user selection

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

Community Browser