Newbie Question. . .

Wed, 29 Apr 2009 21:12:30 GMT

Hello world,

I have two tables ..... Invoices and Dealers both containing a dealer field.

My problem is that i have several countries in my Invoices table and I would like to get the data only about a single country. The Dealers table is containing the necessary data about the country but once my chart is created I still get the data related to others dealers saved in the Invoices table.

Do you have a solution?

Thanks,

Newbie Question. . .

Wed, 29 Apr 2009 21:22:44 GMT

Set analysis should be able to handle this.

In your chart expression, use something like:

Sum( {<Country={Canada}>} Sales)

Country would be the name of your country field. See the reference manual (and this forum) for more details on Set Analysis.

topic Newbie Question. . . in QlikView

Newbie Question. . .

Newbie Question. . .