topic RE:Selected range in QlikView

RE:Selected range

Chanty4u — Wed, 16 Dec 2015 12:25:47 GMT

hi,

how to bring cumulative sum based on selected range

consider am selecting 03/12/2105 ; I need sales till that date not YTD?

Any idea?can anyone suggest?

thanks in advance

Re: RE:Selected range

MK_QSL — Wed, 16 Dec 2015 12:39:29 GMT

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

Re: RE:Selected range

Chanty4u — Wed, 16 Dec 2015 12:43:42 GMT

thnx manish...

but its giving only selected value sum; not till date

Re: RE:Selected range

MK_QSL — Wed, 16 Dec 2015 12:48:08 GMT

Consider that you have selected 03/12/2105

If you want 01/01/2015 to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

If you want min Date to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=Min({1}Date))<=$(=Max(Date))"}>}Sales)

Re: RE:Selected range

Anonymous — Wed, 16 Dec 2015 12:57:44 GMT

try this:

=SUM({< Year=, Quarter=, Month=, Week=, Date = {'<=$(=Max(Date))'}>}Sales)

It will give you till date only

Re: RE:Selected range

Chanty4u — Wed, 16 Dec 2015 13:02:39 GMT

can v create an tool tip for list box witout caption?

Re: RE:Selected range

Anonymous — Wed, 16 Dec 2015 13:04:26 GMT

Tool tip?

like this?

Tool Tip

Re: RE:Selected range

Anonymous — Wed, 16 Dec 2015 13:12:41 GMT

for tool tip:

Properties -> Caption -> HelpText (Right Bottom)

Re: RE:Selected range

Chanty4u — Thu, 17 Dec 2015 04:16:24 GMT

hi manish,

dis is also not shwng the sum till date? any other solution?

Re: RE:Selected range

Chanty4u — Thu, 17 Dec 2015 04:16:38 GMT

not wrkng balraj...

Re: RE:Selected range

Chanty4u — Thu, 17 Dec 2015 04:58:33 GMT

thnx manish and balraj... now the exp works fine...

Re: RE:Selected range

jagan — Thu, 17 Dec 2015 05:42:40 GMT

Hi Suresh,

Check this link, there are lot of such expressions in this link

Set Analysis for certain Point in Time

Re: RE:Selected range

Chanty4u — Thu, 17 Dec 2015 05:49:09 GMT

Okay.Thanx jagan