topic Re: how to ignore selection on particular field value in QlikView

how to ignore selection on particular field value

brijeshvma — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: how to ignore selection on particular field value

Chanty4u — Sun, 20 Mar 2016 06:22:40 GMT

chk dis

Set Analysis: Ignore a large group of fields

Ignore all selections except some specific fields using Set Analysis

Re: how to ignore selection on particular field value

brijeshvma — Sun, 20 Mar 2016 06:32:45 GMT

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

Re: how to ignore selection on particular field value

Chanty4u — Sun, 20 Mar 2016 06:41:56 GMT

in cartype filed what are the values u hve?

Re: how to ignore selection on particular field value

HirisH_V7 — Sun, 20 Mar 2016 06:49:25 GMT

Hi,

Check this,

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

HTH,

Hirish

Re: how to ignore selection on particular field value

brijeshvma — Sun, 20 Mar 2016 07:24:08 GMT

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

Re: how to ignore selection on particular field value

Chanty4u — Sun, 20 Mar 2016 07:32:52 GMT

if(get selectioncount(urfiled)>0)

Re: how to ignore selection on particular field value

brijeshvma — Sun, 20 Mar 2016 07:36:01 GMT

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

Re: how to ignore selection on particular field value

Chanty4u — Sun, 20 Mar 2016 07:44:37 GMT

u can try

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

Re: Re: Set Analyses Exclude Selection

Re: how to ignore selection on particular field value

brijeshvma — Sun, 20 Mar 2016 08:00:14 GMT

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...

Re: how to ignore selection on particular field value

Chanty4u — Sun, 20 Mar 2016 08:01:17 GMT

small chnge

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

Re: how to ignore selection on particular field value

avinashelite — Mon, 21 Mar 2016 05:34:29 GMT

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))

Re: how to ignore selection on particular field value

kkkumar82 — Mon, 21 Mar 2016 05:59:20 GMT

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

Re: how to ignore selection on particular field value

tyagishaila — Mon, 21 Mar 2016 07:02:23 GMT

You can make Listbox of CardTypeSub as Read Only.

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

Re: how to ignore selection on particular field value

NareshGuntur — Mon, 21 Mar 2016 07:33:50 GMT

Hi Brijesh,

Did you try this?

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

Cheers,

Naresh

Re: how to ignore selection on particular field value

brijeshvma — Mon, 21 Mar 2016 08:03:43 GMT

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

Re: how to ignore selection on particular field value

Chanty4u — Mon, 21 Mar 2016 08:07:50 GMT

is this?

Re: how to ignore selection on particular field value

brijeshvma — Mon, 21 Mar 2016 08:27:27 GMT

Yup.. This QVW

Re: how to ignore selection on particular field value

tyagishaila — Mon, 21 Mar 2016 08:39:06 GMT

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

Re: how to ignore selection on particular field value

sunny_talwar — Mon, 21 Mar 2016 08:49:39 GMT

May be like attached