Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner - Creator
Partner - Creator

How to Ignore List box other Value Apart from One

Hi ,

I have Concatenate 3 Fact table .. Fact A, B , C . But in Fact B i have two Subgroup B1 and B2 as well...

[Sales Master]:

Location,

Sales,

'Sales A' as Flag

from Sales A table;

Concatenate([Sales Master])

Location,

Sales,

Style as SubFlag,

'Sales B' as Flag

from Sales B table;

Concatenate([Sales Master])

Location,

Sales,

'Sales C' as Flag

from Sales C table;

In want to Show Each Sales in KPI on same DashBoard.

1st KPI Expression :  sum({ <Flag ={ 'Sales A'}>} Sales)

2st KPI Expression :  sum({ <Flag ={ 'Sales B'}>} Sales)

3st KPI Expression :  sum({ <Flag ={ 'Sales C'}>} Sales)

4st KPI Expression :  sum({ <SubFlag ={ 'Sales A'}>}Sales)

5st KPI Expression :  sum({ <SubFlag ={ 'Sales A'}>} Sales)

I have Two List Box for Flag and SubFlag

1 St List Box

Flag
   Sales A
   Sales B
   Sales C

And 

SubFlag
Top
Bottom

But When Customer selecting List Box Value other KPI value show 0. Say Example

Cust Selected Sales B than on KPI 2 Shows Sum(Sales) for B table .. But Other KPI shows ZERO...

I want if cust select any List box value either in Flag or Subflag it Just ignore the selection ..

Means if cust select Subflag Top.. Still All kpi shows its value as per there Expression.

3 Replies
brijeshvma
Partner - Creator
Partner - Creator
Author

Hi ,

some changes .. that i written previously

4st KPI Expression :  sum({ <SubFlag ={ 'Top'}>}Sales)

5st KPI Expression :  sum({ <SubFlag ={ 'Bottom'}>} Sales)


sunny_talwar

It seems weird that its doing that. Because ideally once you have told the expression that look at Flag = 'Sales A', it should not change the result of expression based on any selection in Flag field. Would you be able to share a sample where this is happening?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

When you select a value in the SubFlag list, you are limiting the data to those rows that match the SubFlag selection. Using Set Analysis to <Flag ={ 'Sales A'}> is an additive selection, it does not not remove the SubFlag selection.

For those flags that don't have a SubFlag, you should add a modifier to ignore SubFlag.

sum({ <Flag ={ 'Sales A'}, SubFlag=>} Sales)


-Rob

http://masterssummit.com

http://qlikviewcookbook.com