Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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,

I was wondering can we display the day name also along with the date.

For eg: now it shows date: 8/3/2015...etc

can i show monday.....below date.

sunny_talwar

May be this as your calculated dimension:

=Date & Chr(10) & Date(Today(), 'WWWW')

markgraham123
Specialist
Specialist
Author

Actually i tried this before, but not working.

Here are the snapshots.

1.PNG

2.PNG

sunny_talwar

It must be there, just not visible, try pressing Shift +Ctrl and when you see the red lines on the chart, move it upwards

sunny_talwar

See this:

Capture.PNG

markgraham123
Specialist
Specialist
Author

Sunny,

When i download ur app.

Day name is not showing in my PC

sunny_talwar

May be its due to version difference. What version of QlikView are you using???

markgraham123
Specialist
Specialist
Author

QV10 bro.

markgraham123
Specialist
Specialist
Author

=WeekDay(Date)&' -'&Date

The above expression worked.

sunny_talwar

I thought you wanted the axis to show in two rows. that's why I gave you a solution with Chr(10)

I am glad you got it figured.

Best,

Sunny