Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am very new to Qlik, and I would appreciate some help. I am trying to set up a visualization to show the number of adjustments made per month over a period of time. But the analysis is done as of the Prior Month's end. So I prepare in November for October. So I would like to exclude the current month from the line chart.
I need to have other visualizations on the same sheet that show a breakdown of the Month that is being presented, so in this example October. So I have opted to use the sheet filter to only show October for the visualizations, and I have excluded the sheet filters from the one trend chart.
When I use the below it looks fine, but this obviously isn't dynamic and would require me to update the script each month
Count({1<[BU]={[ABC],[DEF],[GHI],[AdjustmentCategory]={[Cash]},[D_YEAR]={'2022'},[Status]={'Approved'},[UploadedBy]={*}-{[JKL],[MNO]},[Region]={[PQR],[STU]},[D_MONTH]={*}-{[Nov]}>}AdjustmentID)
I thought the below would work, but when I phrase it like this it just doesn't show anything
Count({1<[BU]={[ABC],[DEF],[GHI],[AdjustmentCategory]={[Cash]},[D_YEAR]={'2022'},[Status]={'Approved'},[UploadedBy]={*}-{[JKL],[MNO]},[Region]={[PQR],[STU]},[D_MONTH]={*}-{Month(Today())}>}AdjustmentID)
I would greatly appreciate if someone could offer some help
Try with this
{[D_MONTH]-= {"$(=Date(MonthStart(Today()), 'MMM'))"}