Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
vardhancse
Valued Contributor III

Unique Dimension Values in Chart/Table

Hi,

We have one table format something like below:

IDNameRegion
111ABCAmerica, London, Singapore
222BCDDubai, Japan
333CDESingapore

 

In script have used sub field to make, Region to show only one country, something like below

IDNameRegion
111ABCAmerica
111ABCLondon
111ABCSingapore
222BCDDubai
222BCDJapan
333CDESingapore

 

now issue is like. for count have taken count(Distinct ID), but when we show in table name format name is getting repeated multiple times based on number of countries

Is there a way to show only unique names as well in table.

Labels (1)
2 Replies

Re: Unique Dimension Values in Chart/Table

Use Pivot Table

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mahaveerbiraj
Contributor II

Re: Unique Dimension Values in Chart/Table

Hi Varda,

could you please attach  qvf file, So that i  can check.