Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Qlik Sense: Create Separate tables

I have a table with 3 columns (A = Country, B= State, C = City) and 100 rows of data:

I would like to create 3 separate tables by each Country. Exampe; 1st table by showing only data for USA. 2nd table by showing only data from Japan and so on.

Can this be done by using a formula in expression editor for a dimension Country?


Thanks in advance.



1 Reply
New Contributor III

Re: Qlik Sense: Create Separate tables

Hi Raghu,
If you are working with only 3 Countries Maybe you can add 3 calculated columns at Data Manager only with that country values and the you can get the 3 separtes tables very easy.
if you can share an example of data maybe I can try to do an example.