topic Re: Get selected count in QlikView

Get selected count

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

Hai,

sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)

can anyone explain how does it works..what is the result of this.

Thanks in advance

Re: Get selected count

kaushiknsolanki — Wed, 01 Feb 2017 06:57:43 GMT

HI,

The flow of expression is this way.

If the Value is not selected in Filters like Month, Day and Year then sum the qty of any value is selected from any of this 3 filters then sum the Month Qty.

Regards,

Kaushik Solanki

Re: Get selected count

surendraj — Wed, 01 Feb 2017 06:59:43 GMT

Suppose you have..fields month,day,year

if you select any one/two of above three fields TRUE statement will be exicuted.(qty)

if you select three of above fields FALSE statement will be exicuted.(mnth_Qty)

Re: Get selected count

Anil_Babu_Samineni — Wed, 01 Feb 2017 07:00:07 GMT

This will working as like below

If no selections Sum(qty) else Sum(mnth_qty)

Re: Get selected count

Anonymous — Wed, 01 Feb 2017 07:02:33 GMT

getselected count function is count the value ,right.and then it'll check condition.am i right.is there any option instead of this function

Re: Get selected count

surendraj — Wed, 01 Feb 2017 07:06:55 GMT

Hi Anil,

Here or is included in between the conditions.so if he may select any one of the field that will be true.

In above if one condition is true then true is executed.

Am i correct?

Re: Get selected count

omkarvamsi — Wed, 01 Feb 2017 07:08:57 GMT

Hi,

sum(if(getselectedcount(month)=0 or getselectedcount(day)=0 or getselectedcount(year)=0,qty,mnth_qty)

getselectedcount(field) :Gets the output of number of values which we selected from field.

if you select jan,feb from month field,the output will be 2.

so when ever you didn't make any selections on any one of month,day,year.

the output will be =0,

The condition becomes true because the selection count of the field =0.So the the "Qty" will be the result.

else "mnth_qty"

Hope i make it clear for you

Re: Get selected count

surendraj — Wed, 01 Feb 2017 07:09:34 GMT

yes..suppose if u select 2 fields from month field.then getselectedcount(month)=2..

Re: Get selected count

Anil_Babu_Samineni — Wed, 01 Feb 2017 07:11:23 GMT

Assumption is correct

If you select anything from those three statements it will give True condition or else false condition

Reply for Last response, yes you are right. There is no other option. Only we have GetSelectedCount() it will get the count of dimension where out static value gives.

Re: Get selected count

Anonymous — Wed, 01 Feb 2017 07:12:36 GMT

Thanks to all.

Re: Get selected count

sravanthialuval — Wed, 01 Feb 2017 07:13:06 GMT

Hi,

It will work based on 4 cases:

1. if you select only month filter result is true and display qty.

2. if you select month and day, result will be true and display qty.

3.if you select month,day and year result will false and display mnth_qty.

4.Even if you not select any filter, result will be true and display qty.