Blanks in pivot & unable to create cyclic group

[mishraamit2485]

Hi All,

I have a heatmap to work on...

1st Prob:

Now in one representation(Rep 1) some blanks are coming like (Product 1,2,3 does not exist for country D and product 7 not for B), see the app, but same case is not there with Rep 2.

Now my problem is I want show this "-"  in Rep1 as something which can help user to tell that this product does not exist, any way to do that.

2nd Prob:

In the above e.g. Country dim is actually a cyclic group(Region,SubReg,Country) some how i'm able to crate the cyclic group but whn I'm moving it to next box it is converting into a single dimension, why is that happening.

[mishraamit2485]

Any help.

[Anonymous]

please check your Group definitions!

under documnet properties\Groups there are None defined!

[mishraamit2485]

I can see there is one group under DocProp\Grps

[Anonymous]

thats's what I see. how come?

[mishraamit2485]

please see the QVW i have attached in the beginning, not able to attach in the reply section so attached there.

Also how did you attach the screenshot? with the !App i'm not able to see any option to paste a screenshot from the desktop.

[kkkumar82 · Accepted solution]

Hi,

for removing '- ', goto presentation tab of the chart extreme bottom left and see two properties "Null symbol" and "Missing symbol" and replace useful text under missing symbol for eg N/A.

Thanks

Kiran Kumar

[Anonymous]

the Screen shot is from your app.

if you copy something and paste it in the reply section (strg+v) i can insert the copied item

[mishraamit2485]

Thanks Kiran for the reply, by any chance can we put any color in the box along with N/A?

[kkkumar82]

Hi Amit,

goto expressions tab and click '+' symbol of the respective expression and try to write an expression for "background color" for eg if (isnull(field), rgb(n1,n2,n3) or colorname)

Thanks

kiran kumar