topic Re: Re: 2 questions in QlikView

2 questions

Thu, 05 Sep 2013 08:15:22 GMT

1. Whenever there is a empty cell in the pivot table the color changes back to default, I want it to stay the same.

2. How to label the values instead of just 1 -2-3-4-5 etc , do I need to change the data? for the dimensions

Re: 2 questions

kaushiknsolanki — Thu, 05 Sep 2013 08:20:52 GMT

Hi,

As i can see in the image you have uploaded.

1. There is an expression written for the coloring, so you can change that expression as you want.

2. Yes you need to change the data if you want the dimension values to be changed (Display something else instead of 1,2,3,4,5....)

Regards,

Kaushik Solanki

Re: Re: 2 questions

Vegar — Thu, 05 Sep 2013 08:52:18 GMT

1. The trouble for coloring is that the data you want to color does not excist. I have not found any way to do this coloring in the chart. A workaround is to make the chart transparent and to put a color scheme in the background.

2. If you define your numerics as a dual() you will have the benefits of the numeric value and the presentation in text.

Re: 2 questions

Thu, 05 Sep 2013 09:43:16 GMT

Hi Vegar,

1. That is a clever workaround. Thanks.

2. Good, I will google around a bit and figure out how it is done!!