Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

master_student
Contributor II

No expression result

Hello community

I would like to calculate the budget of maximum date in my excel file.

To do so, I created a variable vMaxdb =date(max(dateBudget), 'DD MMM YYYY')

and then in my expression :=sum({<[dateBudget]={$(#vmaxdb)}>}[Budget PO]/1000)

It didn't work.

Do you have an idea please.

Thanks

15 Replies
oknotsen
Honored Contributor III

Re: No expression result

Notice the hash sign (the "#") in your expression. That should not be there as far as I know. Remove it and see what happens. I probably would replace it by an "=".

May you live in interesting times!
mauricewehbe
Contributor

Re: No expression result

Hi Wiem,

if you want to force vmaxdb date to be evaluate as a number user this:

sum({<[dateBudget]={'$(#=vmaxdb)'}>}[Budget PO]/1000)

Hope this help

Maurice

mithilesh17
Contributor

Re: No expression result

Hi,

Remove # symbol.

Regards,

sureshqv
Esteemed Contributor III

Re: No expression result

hi,

Remove  # symbol and replace with =

Re: No expression result

May be this:

=Sum({<[dateBudget]={"$(=Date(Max(dateBudget), 'DD MMM YYYY'))"}>}[Budget PO]/1000)

master_student
Contributor II

Re: No expression result

Hello,

I tried but it didn't work.

My goal is to display the budget By

month :

MTD , from first january until mnt po (in my excel file is not null)

and YTD

Could you send me your emails, I can't attach any file here...

Thank you for your help

Re: No expression result

try this

=sum({<[dateBudget]={"$(=vMaxdb)"}>}[Budget PO]/1000)

hirishv7
Honored Contributor

Re: No expression result

Hi,

Check with this,

sum({<[dateBudget]={'$(=Date(max([dateBudget]), 'DD MMM YYYY'))'}>}[Budget PO])/1000

Whether your Date format is  of same , dateBudget - 'DD MMM YYYY'   or not.

-Hirish

Re: No expression result

I am not sure who are you referring to in your post?

Community Browser