topic Re: Variable in QlikView

Variable

smilingjohn — Thu, 15 Oct 2015 06:33:51 GMT

I have two variable one variable has vStartDate and another is vEndDate

Now i have to display the value in two text box

value for start date And iam trying to use this formula but iam geting a dash symbol

if(Date=vStartDate ,sum(netAmount))

if(Date=vENdDate ,sum(netAmount))

Can plz some one correct the expression ?

Re: Variable

hic — Thu, 15 Oct 2015 06:36:40 GMT

"Date" is a naked field reference and will be evaluated to NULL, since there are several possible values.

See Use Aggregation Functions!

HIC

Re: Variable

SreeniJD — Thu, 15 Oct 2015 06:49:51 GMT

Try this -

If(Min(Date(DateField))=vStartDate,Sum(netAmount))

If(Max(Date(DateFIeld))=vEndDate,Sum(netAmount))

Sreeni

Re: Variable

tamilarasu — Thu, 15 Oct 2015 07:06:35 GMT

Hi John,

Could you post your expected output (I could see you are struggling to get the final result).? If we know your full expectation, we can guide you to achieve final output in one go.!!

Re: Variable

smilingjohn — Thu, 15 Oct 2015 07:23:26 GMT

Hi Nagraj

Its the same file u sent me after modifying , My requirement is like i want to show a sum of value for perticular SBU and location only for start date

and another text object which should show the value for end date .

i hope iam clear .

Re: Variable

tamilarasu — Thu, 15 Oct 2015 07:50:27 GMT

If the dates (in your case PERIOD_START_DATE and SCHEDULE_CLOSE_DATE ) are falls between start date and end date, you need to show the sum value. Right?

If you mention the start date as 01.12.2013 and end date as 31.12.2013, the textbox should display the sum value (PERIOD_START_DATE and SCHEDULE_CLOSE_DATE falls inbetween the start date and end date).

Correct me, If I am wrong.

Re: Variable

Anonymous — Thu, 15 Oct 2015 08:12:55 GMT

if(Date=vStartDate ,sum(netAmount))

Date is an internal function and Need a Parameter

hwat date do you want to compare? today, specific date?

then try

if (today()=vStartDate,...

if (date(mydate)=vStartDate,...

Re: Variable

Digvijay_Singh — Thu, 15 Oct 2015 08:14:05 GMT

try -

Sum(if(Date=vStartDate ,netAmount))

Sum(if(Date=vENdDate ,netAmount))

Re: Variable

smilingjohn — Thu, 15 Oct 2015 08:36:10 GMT

Actaully i need to show a text objec which shoul show the sum(value) for PERIOD_START_DATE

and one more text object which should show me SUm(value) for SCHEDULE_CLOSE_DATE.

and also please if u can just let me know , how do i implement this in charts expression , i just want to pass this value

Re: Variable

tamilarasu — Thu, 15 Oct 2015 08:45:59 GMT

Ok got it. I'll check

Re: Variable

tamilarasu — Thu, 15 Oct 2015 09:35:34 GMT

Hi John,

Please check the attachment. You can mention start date and end date in input box. Based on that the two text boxes will display the sum values.

Let me know if you have any clarifications !.

Re: Variable

smilingjohn — Thu, 15 Oct 2015 09:38:35 GMT

Thanks for your time Nagraj