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.

1 Solution

Accepted Solutions
sunny_talwar

Try this in your set analysis:

{<Date = {"$(='>=' & Date(WeekStart(Today()), 'yourDateFormat') & '<=' & Date(Today(), 'yourDateFormat'))"}>}

View solution in original post

29 Replies
settu_periasamy
Master III
Master III

May be try this

=if(Match(WeekDay(Today()),'Mon','Tue'),FiscalWeek)

markgraham123
Specialist
Specialist
Author

Hi,

But, it my barchart should change when i reload it on wednesday.

It should be like MOnday, tuesday, wednesday of current week

settu_periasamy
Master III
Master III

i don't understand fully. But, if your day like Monday, Tuesday.. like that you can use

=DATE(Today(),'wwww')

you can use match or if function.

markgraham123
Specialist
Specialist
Author

Hi,

Lemme be clear.

The bar chart should have the x-axis values of current fiscal week.

FYI I do have a field called fiscal week in the model.

settu_periasamy
Master III
Master III

May be you can try to change the Sum(Amount) as

Sum({<Yourdatefield={'$(=Today())'}>}Amount).

Just an assume. is it possible to post the sample?

markgraham123
Specialist
Specialist
Author

Here the sample app. is friend.

I wanna see jus current week in x-axis.

markgraham123
Specialist
Specialist
Author

the problem is i was not able to show the label on the x-axis.

sunny_talwar

Try this in your set analysis:

{<Date = {"$(='>=' & Date(WeekStart(Today()), 'yourDateFormat') & '<=' & Date(Today(), 'yourDateFormat'))"}>}

settu_periasamy
Master III
Master III

Hi,

Check the attachment, May be help you..