Qlik Community

Technology Partners Ecosystem Discussions

Qlik Technology Partners Ecosystem

Highlighted
Geeks
New Contributor II

Creatingdynamic column presenting unique values

Hi Team, 

 

I have a below data set:

ID, Sales

A, 100

B,100

C,200

D,300

E,400

I want the below output in front end table:

ID, Sales, Number

A, 100, 1

B,100, 1

C,200, 2

D, 300, 3

E,400, 4

 

The above number column should be dynamic .

 

Thanks in Advance

6 Replies
Highlighted
Partner
Partner

Re: Creatingdynamic column presenting unique values

Hi,

Please find Attached QVF for your reference.

Highlighted
Geeks
New Contributor II

Re: Creatingdynamic column presenting unique values

I ma unbale to open the document in QV pE. Could you please post it here ?

Highlighted
Partner
Partner

Re: Creatingdynamic column presenting unique values

 
Highlighted
Geeks
New Contributor II

Re: Creatingdynamic column presenting unique values

Hi,

As per your solution : 

left(Sales),1- Will always the count the first letter of dimension iie

ID, Sales

A,100->left(Sales),1 ->Coutinng 100 as 1 ie the first digit of a number

B,100- Picking first digit of 100 whic is 1

 

When the numbers will change , for instance

ID, Sales

A, 500 ->Left(Sales),1 wil give 5 which is not the desrired thing, it should return 1 as unique

B,500

C,600 

Highlighted
Partner
Partner

Re: Creatingdynamic column presenting unique values

Can you explain more on the requirement.

Highlighted
Partner
Partner

Re: Creatingdynamic column presenting unique values

Suppose you have

ID, Sales

A, 400

B, 100

C, 900

D, 500

F, 1000

E, 4400

What should be the numbers in the desired output??