Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm plotting a line chart, where the dimension has many date values in the x-axis. Need to reduce the frequency of dimension as once in 3 days. Please advise. Thank you
In properties > axis select a static step of 3.
Yeah, tried your suggestion. Still it didn't work. Below is the screen shot of the axes tab. Thanks
You need to do it in the lower half (dimension axis) not the upper half (expression axis).
Select Continuous. Unselect Stagger Labels.
You should then be able to enter a Static Step on the dimension.
Yeah, I tried your suggestion.
If i'm not wrong the x-axis contains date values which on converting to number type may work.
Attached the screen shot of chart area after selecting continuous check box Please advise.
Thank you
Not sure. Your axis does have to be numeric.
And from here I can't tell if it is. it would seem that Qlikview doesn't think it is.
Is your field actually a date and time field? I think you may need to use a date only field.
Yeah, the source is from a CSV file and the column, earlier was timestamped. But after your suggestion converted it to date only column. Still it didn't work.
insert sad face.
can you upload a sample file?
Ahhh.... I tried to reduce the x-axis interval by using MOD(DATE,3) = '0' through script and it worked now. Thanks
Glad to hear it!