Solved: Re: Display current fiscal week in barchart - Qlik Community

markgraham123 · ‎2015-08-07

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.

sunny_talwar · ‎2015-08-07

Try this in your set analysis:

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

settu_periasamy · ‎2015-08-07

May be try this

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

markgraham123 · ‎2015-08-07

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 · ‎2015-08-07

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 · ‎2015-08-07

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 · ‎2015-08-07

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 · ‎2015-08-07

Here the sample app. is friend.

I wanna see jus current week in x-axis.

markgraham123 · ‎2015-08-07

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

sunny_talwar · ‎2015-08-07

Try this in your set analysis:

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

settu_periasamy · ‎2015-08-07

Hi,

Check the attachment, May be help you..