Row Data Manipulation in Qlikview

[ramyasaiqv]

Hi Qlik Gurus,

I got a request from the user and I’m not sure if this functionality is possible in qlikview. So please help me if you can

I have a straight table with multiple dimensions and metrics. The Dimension has multiple values and by default the report should show the corresponding value on all the rows that’s normal

Here is the new request For example if the user selects a particular value of the dimension it should apply that value by replacing the actual value on all the rows

To make it more clear I have attached a small test app with the data set.

As shown on the UI “Test” dimension has  (L+3, L+7, M+L and P+D) as values and by default the table should display all the rows with respective L+3, L+7, M+L and P+D values

But for example if the user selects  L+3  on the list box or in the “Test” dimension drop down list instead of narrowing down the result set  to just single row of  L+3 , it should replace all other rows(three) with L+3

So please try to help, thank you for your time and really appreciate your help. Thank you, ! !

[sunny_talwar]

May be using an expression:

[Anil_Babu_Samineni]

I request you to don't create double threads for one solution. Here you go

Row Data manipulation

[ramyasaiqv]

That's what i wanted. Thank you very much Anil and Sunny.

[sunny_talwar · Accepted solution]

Great, please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[ramyasaiqv]

Sorry initially i was bit confused where and how to post. Thank you

[Anil_Babu_Samineni]

No Worries, If you create multiple thread for single issue. Our helpers might confused nothing more. Any how, Please flag the correct answer of Sunny Reply.