Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

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

Re: Display current fiscal week in barchart

Try this in your set analysis:

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

29 Replies

Re: Display current fiscal week in barchart

May be try this

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

markgraham123
Contributor II

Re: Display current fiscal week in barchart

Hi,

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

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

Re: Display current fiscal week in barchart

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
Contributor II

Re: Display current fiscal week in barchart

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.

Re: Display current fiscal week in barchart

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
Contributor II

Re: Display current fiscal week in barchart

Here the sample app. is friend.

I wanna see jus current week in x-axis.

markgraham123
Contributor II

Re: Display current fiscal week in barchart

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

Re: Display current fiscal week in barchart

Try this in your set analysis:

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

Re: Display current fiscal week in barchart

Hi,

Check the attachment, May be help you..

Community Browser