Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Choice of countries in a table

Hello,

I have a question. After creating a comparative table with the calendar a tool.

I would like to create a table with sales in two countries : countries1 and countries2. These two countries must be chosen by the user. How is this possible in QlikView?

Thank you in advance.

3 Replies
Not applicable
Author

It depends on how it should work and look.

You can create a straight table with dimention "countries" and on the first properties window create a rule that it should only work (calculate) when two and only two countries are selected.

I can provide a sample app if you like

Or give as more information about what you want to get.

Not applicable
Author

You can use variables to select value from field and use the variable in set analysis for the table.

Not applicable
Author

In my table, I have the turnover of all the stores and therefore different countries. The country is in the same table.

So I would like a table that resembles the following:

Type of products          Country 1               Country 2         

Product1

Product 2

...

Sum

Thank you.