topic Re: Filter between tablebox and chart in QlikView

Filter between tablebox and chart

Mon, 16 May 2016 11:36:32 GMT

Hi all,

I have table box showing the

time,tradeno clientname clientNo branch Amt Product

and chart showing the sum of amt (sales) based on the the time.

How can i do :

when i click on any data in the tablebox like clientno, clientname,tradeno etc , i want pass the time as my filter to the chart.

Thanks

Re: Filter between tablebox and chart

sunny_talwar — Tue, 17 May 2016 00:32:54 GMT

How can i do :

when i click on any data in the tablebox like clientno, clientname,tradeno etc , i want pass the time as my filter to the chart.

Not sure I understand your request. Would you be able to provide a sample so that we can visualized what you are trying to do.

Best,

Sunny

Re: Filter between tablebox and chart

swuehl — Tue, 17 May 2016 00:52:53 GMT

If you want to consider the possible values for time (limited by your selections in the other fields), but disregard any other selections in your aggregation, try something like this in your chart expression:

=Sum({1<time = p()>} Amt)

=Sum({<time=p() ,tradeno, clientname, clientNo, branch, Product>} Amt)