how to ignore selection on particular field value

[brijeshvma]

Hi All,

I have a Drill Dimension : TAB > CITY

and Expression :Count({<Category= {'home_screen'},Action={'Scroll_to_tab'}>} VID)

And i have one more Field CardTypeSub . i want if user select CardTypeSub value nothing will change.

means it ignore the selection for CardTypeSub .

i tried ,

Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=>} VID)

... But with this expression ... it drill the value automatically in city level..

i want if user select CardTypeSub ... nothing will get change..

Kindly help me on this..

[Chanty4u]

chk dis

Set Analysis: Ignore a large group of fields

Ignore all selections except some specific fields using Set Analysis

[brijeshvma]

Hi Chanty ,

I already checked this linked ... But i am not getting any solution for the same ,, Can u help me with

Expression ... what to write

[Chanty4u]

in cartype   filed what are the values u hve?

[HirisH_V7]

Hi,

Check this,

Only({<Customer-={'ACS'}>}Sales)

HTH,

Hirish

[brijeshvma]

Hi ,

My Field TAB and CardTypeCity are two different field ... and both are not related to each other..

I am sharing my Qvw ...kindly chek

i Drill Dimension TAB and CITY .... and CardTypeSub is another list box field..

I just want if user select any values in CardTypeSub.. My Chart dont get change

[Chanty4u]

if(get selectioncount(urfiled)>0)

[brijeshvma]

I tried this as well,,

But if i am using this.. Its Showing all the values in Tab Field ... its not showing value based on

Category= {'home_screen'},Action={'Scroll_to_tab'} this condition

[Chanty4u]

u can try

=sum({1<CardType={'values'}>} CardTypeSub)

• Re: Re: Set Analyses Exclude Selection

[brijeshvma]

Hi,

Please check the expression and question of mine

I want to allow selection on all except CardTypeSub...

And ur expression shows select value of CardTypeSub except other...