Display current fiscal week in barchart

[markgraham123]

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.

[markgraham123]

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]

Actually i tried this before, but not working.

Here are the snapshots.

[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:

[markgraham123]

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]

QV10 bro.

[markgraham123]

=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