Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
raghu0303
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.

Regards,

Raghu 

1 Reply
Highlighted
Diter
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.

regards,