topic Re: Pls help .. its urgent............. variable issue in QlikView

variable issue

Fri, 05 Jun 2015 16:28:43 GMT

Hi Experts,

I have to set variable for the following expression

'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

when i give like

vCurrMnth='>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

it is giving error.

Pls help me to solve this

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 16:33:05 GMT

Try defining the variable like this may be and check if that works:

vCurrMnth= ='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate))

Best,

Sunny

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 16:38:41 GMT

its showing null value

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 16:41:14 GMT

Are you using the above in a set analysis expression?

There are few things that could be going wrong?

1) variable should be ='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate)) with the equal sign

2) What is vMaxSalesDate? Is it an actual date?

Would you be able to share a sample application?

Re: Pls help .. its urgent............. variable issue

b_garside — Fri, 05 Jun 2015 16:43:43 GMT

Is this being used in a Calendar object as a search string?

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 16:46:54 GMT

vMaxSalesDate=Date(Max(Calendardate))

i try checking with text box.

it is just displaying as it is

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 16:47:52 GMT

i hav to use this in an expression of pivot table.

pls help

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 16:48:59 GMT

Are you trying vCurrMnth or $(vCurrMnth)? My guess is that you are trying vCurrMnth. Try $(vCurrMnth) and see what you get.

Best,

Sunny

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 16:54:33 GMT

now the text box is showing value as

>= 01/06/2015 <= 05/06/2015

i need to use the below exprn in pivot table.

SUM({<MonthYear=,Date={'$(vCurrMnth)'}>} DAYS)

its showing null values

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 16:59:46 GMT

What is the format of MonthYear? If it is anything except 'DD/MM/YYYY', you won't see any results. You need to change the format of your variable to the same format as MonthYear.

HTH

Best,

Sunny

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 17:03:18 GMT

Hi,

Monthyear is like MMM YYYY (jun 2015)

ok i removed it and used date alone.

date format is DD/MM/YYYY.

but still null values.

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 17:03:35 GMT

Any other suggestions plssssssssssss

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 17:06:30 GMT

Sorry I misread your earlier expression, it was correct if Date is DD/MM/YYYY then you had it right. Only other thing I can think of is to try it like this:

=SUM({<MonthYear=, Date={"$(vCurrMnth)"}>} DAYS)

Re: Pls help .. its urgent............. variable issue

Fri, 05 Jun 2015 17:11:45 GMT

showing garbage after '<='

Re: Pls help .. its urgent............. variable issue

sunny_talwar — Fri, 05 Jun 2015 17:14:20 GMT

Hahahaha damn it man. Try this I guess:

=SUM({<MonthYear=, Date={"$(='>=' & Date(MonthStart(vMaxSalesDate)) & '<=' & Date(vMaxSalesDate)))"}>} DAYS)

Re: Pls help .. its urgent............. variable issue

maxgro — Fri, 05 Jun 2015 21:50:07 GMT

post your .qvw

or remove the label of your expression and try to find the problem looking at the popup as in image

Re: Pls help .. its urgent............. variable issue

md_qlikview — Sat, 06 Jun 2015 02:47:12 GMT

Yes you can verify your output as mentioned by Massimo. I have created this kind of variable once, but as per my knowledge i simply wrote this as below

'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'

Re: variable issue

pratap6699 — Sat, 06 Jun 2015 20:32:18 GMT

LET vCurrMnth=>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))

=SUM({<Date={"=$(vCurrMnth)"}>} DAYS)