topic Re: Set expression in QlikView

Set expression

Wed, 25 Nov 2020 16:16:04 GMT

Not reading properly please help on below expression

Dimensions> target date,com-code

Sum({<DATE={'$(=Addmonths (DATE,1))'>}sales)

Re: Set expression

PrashantSangle — Tue, 07 Mar 2017 12:01:02 GMT

Hi,

What are trying to achieve? might be date format is change after applying addmonths().

try like

Sum({<DATE={'$(=date(Addmonths(DATE,1),'YourDateFormat'))'>}sales)

Regards,

Prashant

Re: Set expression

yasmeenk — Tue, 07 Mar 2017 12:01:41 GMT

Hi,

What is your exact need?

Re: Set expression

sunny_talwar — Tue, 07 Mar 2017 12:09:39 GMT

I would suggest double quotes for outer single quotes

Sum({<DATE={"$(=Date(Addmonths(Max(DATE), 1), 'YourDateFormat'))"}>}sales)

But this still might not work because you havn't provided the context of what you are trying to do here?

Re: Set expression

Tue, 07 Mar 2017 12:23:45 GMT

Am trying to get for next month no of employees

which is DOJ>TARGET DATE

I have created flag

If(DOJ>Target date,1,0) as flag1

In expression > sum ({<flag={1},......>.}employees)

Any suggestions??

Re: Set expression

sunny_talwar — Tue, 07 Mar 2017 12:26:09 GMT

So what is DATE here?

Re: Set expression

Tue, 07 Mar 2017 12:27:36 GMT

Based on the DOJ here I mentioned only doj

Sum({<flag1={'1'},DOJ={"$()"}>}reqd employee)

Pls help

Re: Set expression

sunny_talwar — Tue, 07 Mar 2017 12:47:26 GMT

Can you provide few rows of sample data and explain the desired output based on your sample?

Re: Set expression

Tue, 07 Mar 2017 12:54:35 GMT

To make a report by using these dimensions

Requisition number,

Requisition date,

Target date,

And expression which I have explained.

Re: Set expression

sunny_talwar — Tue, 07 Mar 2017 12:56:53 GMT

How to get answers to your post?

Re: Set expression

Tue, 07 Mar 2017 13:03:28 GMT

Yes I agreed but currently I can't share.

That's why I posted only expression.

Re: Set expression

Tue, 07 Mar 2017 13:05:04 GMT

Yes I agreed but things are not supposed to share

That's why I posted only my expression where I want to know whether it's correct or not.My apologies!!!

Re: Set expression

sunny_talwar — Tue, 07 Mar 2017 13:07:44 GMT

All I want is dummy raw data which mimics your actual data