Qlik Sense: Create Separate tables

[raghu0303]

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.

Regards,

Raghu 

[Diter]

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.

regards,