expression on dimensions

[#1]

I am attaching sample qvw and my requirement, Please have a look and help me out

[shree909]

Hi find the updates qvw..

is this wat ur looking

goto the presentation tab of the chart and u find null suymbol  and missing symbol

replace - symbols with space  or zeo

that will work...

[Gysbert_Wassenaar · Accepted solution]

Try using set analysis expression like =sum({<A.Cde={'A'}>} B.Cde) instead of the calculated dimension. See attached qvw.

[MayilVahanan]

Hi

PFA

[#5]

Thankyou Gysbert and Ramasamy......I am having one more issue...I just added name field into data and trying to represent in single line with your expression....its showing as 0's please find the attachment...Thankyou

[Gysbert_Wassenaar]

Well, using sum on a text field doesn't make too much sense . In this case you can use only({<A.Cde={'A'}>} Name).

[#7]

Thankyou Gysbert,You are really helpful....I used the below expression

=

concat({$<A.Cde={'A'}>} B.Cde