Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
badamsrinu
Contributor
Contributor

Development

Name, Id

Sriram,1255

Raju, 1289

Jagan,1290

 

End User wanted to see only 1289 value and that should be displayed in next column? How do u achieve it?

Labels (1)
1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

From the description of the post, it is not 100% clear as to which exactly use case scenario you are trying to achieve. It would be helpful to include an screenshot of your current view where you highlight the part that you want the value to be displayed and/or share what you have already tried. 

 

As best effort here are the steps that I have followed to achieve something similar to what you have described:

 

1. I have loaded the sample dataset:

2. For the "next column", I have used the expression:

=Only( TOTAL {<Name={"Raju"}>} Id)

3. After that I have the outcome:


 

As you can see, the table has one column where the value 1289 is the only value displayed. 

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 

 

 

 

 

 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

From the description of the post, it is not 100% clear as to which exactly use case scenario you are trying to achieve. It would be helpful to include an screenshot of your current view where you highlight the part that you want the value to be displayed and/or share what you have already tried. 

 

As best effort here are the steps that I have followed to achieve something similar to what you have described:

 

1. I have loaded the sample dataset:

2. For the "next column", I have used the expression:

=Only( TOTAL {<Name={"Raju"}>} Id)

3. After that I have the outcome:


 

As you can see, the table has one column where the value 1289 is the only value displayed. 

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 

 

 

 

 

 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂