topic Re: Button Selections in QlikView

Button Selections

bharatkishore — Wed, 23 Mar 2016 06:22:49 GMT

Hi All,

I have two charts and a button in one sheet. Now my requirement is if i do any selections in one chart the button(Name is "Clear Filters")

should be able to clear only that particular chart.. It should not reflect the other chart.

Note: I do not want using Alternate States

Thanks,

Bharat

Re: Button Selections

Chanty4u — Wed, 23 Mar 2016 06:27:24 GMT

can u share sample qvw?

is that button hvng trigger with clear all?

Re: Button Selections

Digvijay_Singh — Wed, 23 Mar 2016 06:29:24 GMT

I don't think it is possible without alternate state if there are common fields between both charts. Lets see what others think.

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 06:37:12 GMT

Sorry to say that i cannot share a sample qvw.

No it is not having any actions.

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 06:37:44 GMT

Yes vijay.. there are common fields..

Re: Button Selections

jonathandienst — Wed, 23 Mar 2016 06:39:21 GMT

Alternate states is one way to implement that, but if you want to avoid alt states, use set analysis.

You can override all selections using a set expression like:

Sum({1} Amount)

Or in specific fields using this pattern:

Sum({<Field1=, Field2=>} Amount)

So you could apply one of these patterns to your 'fixed' chart.

I suggest that you upload a sample illustrating what you require for more specific help.

Re: Button Selections

Chanty4u — Wed, 23 Mar 2016 06:40:23 GMT

chk the attached

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 06:47:23 GMT

Thanks Chanty for the reply. The file what you have sent there we have one button, now when you are clicking that button the two charts are getting cleared. But i need only one chart to be cleared and the other one should remain the same.

Re: Button Selections

Chanty4u — Wed, 23 Mar 2016 06:52:53 GMT

chk it

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 06:57:05 GMT

Thanks for the file.. But if you do any selections in the chart and while clicking the button it is clearing the two charts. But if i do filters in one chart the button should be able to clear that chart only.. Not the two charts.

Re: Button Selections

jagan — Wed, 23 Mar 2016 07:01:56 GMT

Hi,

Try like this

Without using Alternate States it is very difficult. The alternate solution is

For example you are using Country field as filter, try like below

Data:

LOAD

Country,

Country AS Country_2,

FROM DataSource;

Now in Sheet1 use Country as filter and in your expression use this

=Sum({<Country_2=>} MeasureName)

Note: you have to use Country_2 in all expressions in Sheet1.

In Sheet2 use Country_2 as filter and use the below expressions

=Sum({<Country=>} MeasureName)

Note: you have to use Country in all expressions in Sheet2.

Hope this helps you.

Regards,

jagan.

Re: Button Selections

Chanty4u — Wed, 23 Mar 2016 07:02:26 GMT

chk now

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 07:32:36 GMT

Thanks Chanty for the reply. But as per ur file i am unable to do any selections in the second chart.

My requirement is i should able to filter the charts(Straight Table) but button should clear only for one chart. It should not clear the two charts.

Sorry if i am not able to explain clearly.

Re: Button Selections

bharatkishore — Wed, 23 Mar 2016 07:43:02 GMT

Thanks a lot Jagan for the reply.

Hope i am clear with y requirement. If not i will explain again:

I have one straight table chart with some fields and i have a button.

Now if you select on any field on the chart the chart will get filtered. Now i need to get as with the help of a button i need to clear the filters made on the chart. Only with button i need to clear it.

Thanks,

Bharat

Re: Button Selections

jagan — Wed, 23 Mar 2016 07:49:48 GMT

Instead of using Clear All, Use Clear Field Country in Sheet1 and Count_2 in sheet. If you have additional repeat this.

This is the only way that we can implement this, otherwise you have to go for Alternate States. Not sure why you are not going for that.

Regards,

Jagan.