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]

small chnge

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

[avinashelite]

Try like this

if (getselectedcount(CardTypeSub)>0 and getselectedcount(CITY)=0, Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=,CITY=>} VID),Count({<Category= {'home_screen'},Action={'Scroll_to_tab'},CardTypeSub=>} VID))

[kkkumar82]

Hi,

better to have two dimensions one with Drill down and other with the first dimension of that drill down, and use condition

"Enable condition" for one of the dimension based on the selection of the field which you want to ignore selections.

Hope I am clear

Thanks

Kiran Kumar

[tyagishaila]

You can make Listbox of CardTypeSub as Read Only.

List Box Properties ---> General Tab ---> check Read Only.

[NareshGuntur]

Hi Brijesh,

Did you try this?

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

Cheers,

Naresh

[brijeshvma]

Hi Naresh ,

No its not working this...Can u please download my qvw file and try to do it on it..

the thing is that same App i need to create in Qliksense as Well... and their as well i am getting an same error

[Chanty4u]

is this?

[brijeshvma]

Yup.. This QVW

[tyagishaila]

There are more options ...

1.)  Create Alternate State for Listbox CardTypeSub

2.) General Tab of Chart

GetSelectedCount(CardTypeSub)=0

if user select any value from listbox of CardTypeSub.... Chart will show

              Calculation Condition Unfullfilled

You can Change this Error like

                    Please clear CardTypeSub  or as you want

[sunny_talwar]

May be like attached