topic Re: No expression result in QlikView

No expression result

master_student — Sat, 02 Apr 2016 22:45:11 GMT

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

Re: No expression result

oknotsen — Sun, 03 Apr 2016 08:52:16 GMT

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 "=".

Re: No expression result

Anonymous — Sun, 03 Apr 2016 09:06:46 GMT

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

Re: No expression result

mithilesh17 — Sun, 03 Apr 2016 09:19:48 GMT

Hi,

Remove # symbol.

Regards,

Re: No expression result

Chanty4u — Sun, 03 Apr 2016 10:16:08 GMT

hi,

Remove # symbol and replace with =

Re: No expression result

sunny_talwar — Sun, 03 Apr 2016 10:24:03 GMT

May be this:

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

Re: No expression result

master_student — Sun, 03 Apr 2016 10:31:47 GMT

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

Kushal_Chawda — Sun, 03 Apr 2016 10:39:03 GMT

try this

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

Re: No expression result

HirisH_V7 — Sun, 03 Apr 2016 10:41:03 GMT

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

sunny_talwar — Sun, 03 Apr 2016 18:10:48 GMT

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

Re: No expression result

master_student — Mon, 04 Apr 2016 16:47:25 GMT

Sunny,

Could you please give me your email. I will send you my application.

Thanks

Re: No expression result

oknotsen — Wed, 06 Apr 2016 06:43:26 GMT

Just attach the application to your post instead.

Re: No expression result

master_student — Wed, 06 Apr 2016 10:02:31 GMT

Hello,

Thanks for your responses.

The problem is solved.

An other question, I have a date fiels in th that format

How to convert it in date without hours, only 29/03/2016

Re: No expression result

oknotsen — Wed, 06 Apr 2016 10:15:09 GMT

Please start a new topic for a new question.

Since your current problem is solved, please flag the correct answer by clicking on the "Correct Answer" button near that reaction. Also consider flagging Helpful answers by clicking on the Action option near that reply and selecting "mark as helpful".

Thank you.

Re: No expression result

Kushal_Chawda — Wed, 06 Apr 2016 10:21:27 GMT

Master_Student‌

Kindly post the solution here and mark it as correct answer so that other can refer to same if they have same issue.

Also for new query please open a new thread.

Re: No expression result

Anonymous — Wed, 06 Apr 2016 10:21:45 GMT

you have assigned wrong variable name .

tryy this

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