Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
You can use variables to select value from field and use the variable in set analysis for the table.
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.