Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I use Count({$<MonthNumber={'$(vMaxMonth)'}>}Data) where my
vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)
it's not working.
I know its very simple, but I think I am missing out something.
Can anyone help on this.
I want to show MaxMonth Data in a TextObject.
Regards,
Renuka S
Hi
Use '=' in variable Created time .
Ex: variable Name : vCurrentYear
=Year(today)
After vCurrentYear variable use : $(vCurrentYear)
Thanks,
I tried this, but it gives me wrong Count.
Regards,
Renuka S
Did you check my .qvw file?
Regards
Pratyush
Then something else is going on. I suggest that you upload a small sample that illustrates the issue (and which does not need contain any sensitive data). Include the expressions you have tried and specify what result(s) you expect.
To upload a qvf file, click 'Use advanced editor'. You can upload a qvf from there,
Hello Renuka,
If you the DateKey as date field then you can make use of below given expression:
=Count({$<MonthNumber = {"=$(=Num(Month(Max(DateKey))))"}>} Data)
Regards!
Rahul
I don't have QlikView installed.
Just try and declare a separate variable for =Max([Fiscal Year]) and use it instead of the function, I did the same and it worked out in qlikview.
Regards
Pratyush
Hi,
I got it, I used it as
vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)
Expression :
Count({$<[Fiscal Year]={"$(=Max([Fiscal Year]))"},MonthNumber={$(vMaxMonth)}>}Data)
Regards,
Renuka S