Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Display current fiscal week in barchart

Hi Everyone,

I have Sold Date, Fiscal week, fiscal month, fiscal year in my data model.

i was trying to plot a bar chart with curretn fiscal week in X-axis and sum(amount) in Y-axis.

If the application gets reloaded tuesday, i need to populate only monday, tuesday of the curretn fiscal week in the x-axis.

Can someone look into this pls.

29 Replies
markgraham123
Specialist
Specialist
Author

Hi Sunny,

Its working with the logic and with the previous logic too.

But i was not able to give labels to the x-axis...

That is the problem.

I'm using Date field as a dimension.

sunny_talwar

Label to x-axis? Not sure what you mean Mark?

markgraham123
Specialist
Specialist
Author

Here is the problem, i have the legend and label enabled...

But no label in X-axis.

date test.png

markgraham123
Specialist
Specialist
Author

date test2.png

Not able to display the date below every bar.

sunny_talwar

Type Date in the below box (the one right below the Label Check box

markgraham123
Specialist
Specialist
Author

I tried that bro.

but not showing anything

sunny_talwar

While on the chart press Ctrl + Shift and when you see red lines, drag the one at the bottom little bit upward. Ensure that you have Date written in the label box underneath the Label checkbox.

HTH

Best,

Sunny

markgraham123
Specialist
Specialist
Author

Sunny, i just deleted that chart recreate dnew onhe.

Its working now.

Thanq bro.

The Saviour....

sunny_talwar

Hahaha ya, that is always an option

I am glad you were able to find a solution. Please close the thread.

Best,

Sunny

sunny_talwar

I just realized that you already did close the thread. Thanks Mark.

Best,

Sunny