Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
raghu0303
Contributor
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.

Regards,

Raghu 

Labels (1)
1 Reply
Diter
Contributor III
Contributor III

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,