topic Re: Filter base Selection in QlikView

Filter base Selection

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

Hi,

I have to show sum of sales for particular location,but if we select other location it should show Zero.

For example:

Country Sales

India 200

US 300

UK 100

Result : when no filter select from Country

India = 200 US = 300 UK =100 /// I am using set analysis for that

If we select India from Country List box

India = 200 US =0 UK =0 // Set analysis is not working it show India=200 US =300 UK =100

Please suggest me how to solve that to retrive the result.

Regards,

Nisha

Re: Filter base Selection

trdandamudi — Thu, 19 Jan 2017 07:13:50 GMT

May be as below:

=If (GetSelectedCount(Country)>0, Sum (Sales),0)

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:16:52 GMT

if the user select India and US then it should be Inid=200 US=300 UK=0 like that

Re: Filter base Selection

Anonymous — Thu, 19 Jan 2017 07:18:10 GMT

Hi Nisha,

Apply GetCurrentSelections() in your expression.

Thanks,

Pooja

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:18:38 GMT

And all those value we have to display in a text box not in a list box

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:22:08 GMT

Hi Pooja,

I tried if(Getselectedcount(Country)=0 or if(match(Getcurrentselections(Country),'Inida'),1),1,0)

but it's doesn't give me result when i m selecting two country at a time

Re: Filter base Selection

trdandamudi — Thu, 19 Jan 2017 07:27:35 GMT

Please see the attached and hope this is what you want:

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:47:18 GMT

i am not able to see your attachment

Re: Filter base Selection

trdandamudi — Thu, 19 Jan 2017 07:54:50 GMT

If you are in the Inbox than you will not see it. just go to the webpage and you will see it..

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:54:58 GMT

In a chart or in list bix it's working fine, but i need to show all those information in text box

Example:

India(text box)

200(Sum({<Country={'India'}>}Sales)) show in a text box

it's work fine if we are not selecting any thing but when i am selecting Country as UK it still show 200 in that text box

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 07:56:02 GMT

Hi Pooja,

I tried this in text box if(Getselectedcount(Country)=0 or if(match(Getcurrentselections(Country),'Inida'),1),1,0)

but it's doesn't give me result when i m selecting two country at a time

Re: Filter base Selection

stabben23 — Thu, 19 Jan 2017 08:12:38 GMT

Do You have Country as Dimension in Your chart?

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 08:14:21 GMT

Hi am not using any chart, i have to shoq all those information in a text box

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 08:15:19 GMT

Thanks,

But that is not what exactly i want, i want all those information in a text box

Re: Filter base Selection

stabben23 — Thu, 19 Jan 2017 08:18:24 GMT

Can you show us that textbox and expected output.

Re: Filter base Selection

tresB — Thu, 19 Jan 2017 08:39:18 GMT

May be like:

Use Implicit set expression like: Sum({<Country*={'India'}>}Sales)

Re: Filter base Selection

trdandamudi — Thu, 19 Jan 2017 08:39:37 GMT

I don't think it is possible to show in the text box the way you want.

Re: Filter base Selection

stabben23 — Thu, 19 Jan 2017 08:44:27 GMT

try this, could be an solution:

=concat(Country,' ')& chr(10) & concat(Sales,' ')

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 08:55:55 GMT

India	US	UK
200	300	100

all are text box,when their is no selection we have filter as a country

when we select any Country such as India and UK then

India	US	UK
200	300	0

Re: Filter base Selection

nisha_rai — Thu, 19 Jan 2017 08:59:35 GMT

Thanks