topic Re: Remove values from X axis for some bars in stacked chart in QlikView

Remove values from X axis for some bars in stacked chart

saumyashah90 — Mon, 21 Sep 2020 03:11:38 GMT

I want to remove this -0 and -1 from X Axis

Re: Remove values from X axis for some bars in stacked chart

saumyashah90 — Mon, 21 Sep 2020 07:14:57 GMT

any response?

Re: Remove values from X axis for some bars in stacked chart

rushikale0106 — Mon, 21 Sep 2020 10:53:25 GMT

Hi Saumya,

Can you please explain your query a bit more? What these values are representing?

If any other case, You can hide the values from the Axes tab in chart properties. The one way I used, by making Axis font color values transparent or changing the color as per the background color.

In any way, let me know about the details issue.

Regards,

Rushika

Re: Remove values from X axis for some bars in stacked chart

saumyashah90 — Tue, 22 Sep 2020 01:33:35 GMT

Hi Rushika,

I have 2 dimensions, 1 is month and other is category. months you can see on x axis and stacks are built out of categories. expression has sum of revenue.

I am not sure why i have -0,0,1 showing for some bar charts and not for others. these numbers are of one of the categories and how can i remove them.

last option would be that i will hide the numbers by adding text.

Re: Remove values from X axis for some bars in stacked chart

Brett_Bleess — Wed, 14 Oct 2020 17:02:06 GMT

I believe the QVW is going to be necessary to look into things further, as the issue likely is in the data model or something, but very difficult to troubleshoot without the application, so if you still need assistance, that is what I would recommend. You can use Settings\Document Properties\Scrambling tab in the Desktop client to scramble any sensitive fields before posting too.

Regards,
Brett