Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Scale in X axis showing dash for no value

Hello

I have a chart. I not have data beyond 3 weeks. However I see dash symbol in scale on x axis. Attaching a screenshot. Any ideas hwo to remove?

Thanks

DV

17 Replies
padmaja_gade
New Contributor III

Re: Scale in X axis showing dash for no value

Suppress Null's under Dimensions:

Capture.PNG

satishkurra
Valued Contributor II

Re: Scale in X axis showing dash for no value

In chart properties under dimensions tab, Check "Suppress when value is NULL"

Not applicable

Re: Scale in X axis showing dash for no value

Thanks. Worked!

Have another question. As you can see, on x axis I have dates (when data was available). I want the scale to have week starts but the data points to still get displayed per date/day. So in a week if I have multiple data points all will be displayed with two scales. Right now my dimension is date_due and those are dates. If I change to weekstart(Date_due) then data points that do not lie on the weekstart date go away. Attached is screenshot. I am new to qlik and might be doing something silly.

Thanks

DV

padmaja_gade
New Contributor III

Re: Scale in X axis showing dash for no value

I am not sure if I understand what is your desired output. But I think this is what you want: try adding a third dimension which calculates for the whole week and hide that dimension.

can you post you sample file? It might help.

Thanks

MVP
MVP

Re: Scale in X axis showing dash for no value

You can leave your dimension date_due like it is now, since you want all dates to be shown.

You can hide the dimension values by using a text color attribute expression (dimension tab - open the attributes by clicking on the small plus sign next to the dimension), something like

=if(Date_due=Weekstart(Date_due), black(), white())

Not applicable

Re: Scale in X axis showing dash for no value

Thanks. Looks like I want exactly the other way around. On the scale I want just week start dates. in the example I attached, 9/30 is not a week start so that should not show up on scale. But the data point for 9/30 should show up in plot area. So I should have three week start dates on x axis scale, 9/21,9/28 and 10/2. and in plot area data points on 9/21,9/28 and somewhere floating between 9/28 and 10/2 (for 9/30 data )

Not applicable

Re: Scale in X axis showing dash for no value

On the scale I want just week start dates. in the example I attached, 9/30 is not a week start so that should not show up on scale. But the data point for 9/30 should show up in plot area. So I should have three week start dates on x axis scale, 9/21,9/28 and 10/2. and in plot area data points on 9/21,9/28 and somewhere floating between 9/28 and 10/2 (for 9/30 data )

MVP
MVP

Re: Scale in X axis showing dash for no value

As far as I understand, you want still to group your data by date, not by weekstart.

I see two possibilites, both use a dimension date:

a) see above, changing the dimension color for certain dimension values, so it appears that you only Show weekstart

b) use a continuous axis and Play aorund with step and min/max values to only show weekstart dates.

Not applicable

Re: Scale in X axis showing dash for no value

Thanks for helping me out. That isnt solving my problem. That indeed whites out the data points that are not week starts. But I want the data points for all date_dues. I just want my scale to show week starts. Attaching a screenshot. As in the graph above the one I changed, I want week starts on x axis scale and datapoints on plot area by dates.

Community Browser