Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Try this in your set analysis:

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

View solution in original post

29 Replies
Highlighted

May be try this

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

Highlighted
Specialist
Specialist

Hi,

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

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

Highlighted

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.

Highlighted
Specialist
Specialist

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.

Highlighted

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?

Highlighted
Specialist
Specialist

Here the sample app. is friend.

I wanna see jus current week in x-axis.

Highlighted
Specialist
Specialist

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

Highlighted

Try this in your set analysis:

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

View solution in original post

Highlighted

Hi,

Check the attachment, May be help you..