Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Restrict Future Data

I want to report through the month which contains the current date... so today is 12/3/15, so I would only want to see data through 12/2015 in my charts. How would I accomplish this? something using If(MonthEnd(today())...?

Dimension: =date(FISCAL_YEAR_MONTH, 'MMM-YY')

Expressions:

$(vRoundBaseAmt) ,

$(vRoundChargedCap) ,

$(vRoundToAU) ,

$(vRoundFromAU) ,

$(vNetAU) ,

$(vRoundAUBudget) ,

Thanks,

Cassandra

1 Solution

Accepted Solutions
cbaqir
Specialist II
Specialist II
Author

I think I got it... =if(monthend(today())>=FISCAL_MONTH_YEAR,date(FISCAL_YEAR_MONTH, 'MMM-YY'))

View solution in original post

3 Replies
sunny_talwar

May be try it like this:

If(DateField <= Today(), $(vRoundBaseAmt)) and so on....

cbaqir
Specialist II
Specialist II
Author

In the Expressions? What I am looking for is essentially this but only for previous and the current month:

12-3-2015 2-41-57 PM.jpg

If I use If(TRX_DATE <= monthend(Today()), $(vRoundBaseAmt)) , it shows as null for previous months.

cbaqir
Specialist II
Specialist II
Author

I think I got it... =if(monthend(today())>=FISCAL_MONTH_YEAR,date(FISCAL_YEAR_MONTH, 'MMM-YY'))