topic Re: expression on dimensions in QlikView

expression on dimensions

Tue, 11 Dec 2012 16:09:12 GMT

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

Re: expression on dimensions

shree909 — Tue, 11 Dec 2012 16:20:12 GMT

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...

Re: expression on dimensions

Gysbert_Wassenaar — Tue, 11 Dec 2012 16:23:59 GMT

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

Re: expression on dimensions

MayilVahanan — Tue, 11 Dec 2012 16:41:16 GMT

PFA

Re: expression on dimensions

Tue, 11 Dec 2012 18:10:35 GMT

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

Re: expression on dimensions

Gysbert_Wassenaar — Tue, 11 Dec 2012 18:53:22 GMT

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

Re: expression on dimensions

Tue, 11 Dec 2012 18:57:15 GMT

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

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