topic Re: selection in Month? in QlikView

selection in Month?

Mon, 15 Dec 2014 06:51:44 GMT

HI All,

I have doubt in MOnth Selection,

If i select Feb then Feb & Jan Should Select,

If i select Apr then Apr,Mar,Feb & Jan Should Select,

If I Select Aug then Aug,Jul,Jun,May,Apr,Mar,Feb & Jan Should Select & So on...

Is this Possible in qlikview...?

please let me know with some example

Regards,

Heather

Re: selection in Month?

its_anandrjs — Mon, 15 Dec 2014 07:00:54 GMT

Hi,

In the list box expression write expression

=if(MonthField <= Max(TOTAL MonthField) ,MonthField)

Ex:-

=if(Month <= Max(TOTAL Month) ,Month)

Regards

Anand

Re: selection in Month?

Mon, 15 Dec 2014 07:33:15 GMT

HI Anand,

I tried , but it's showing Null Value..Can you share any example

Regards,

Heather

Re: selection in Month?

Mon, 15 Dec 2014 07:41:46 GMT

hi,

do you want this for a purticular chart.??

and i guess you want to know that,if you can get month till date.

Reply if that is wat you want

thanks

sudhanshu shrivas

Re: selection in Month?

Mon, 15 Dec 2014 07:48:47 GMT

hi,

you can bypass all the required fields and can use set expression (eg given below..

it will give data for >=num of Yearstart to the current date selected.

=sum({<YearOfOrder=, WeekOfOrder=, DayOfOrder=,

OrderDate={">=$(=Num(YearStart(Max(MonthOfOrder))))

<=$(=Max(OrderDate))"}>} sales)

It will give you data for year till date.

thanks

sudhanshu shrivas

Re: selection in Month?

Mon, 15 Dec 2014 08:17:04 GMT

If i select Feb then Feb & Jan Should Select,

If i select Apr then Apr,Mar,Feb & Jan Should Select,

If I Select Aug then Aug,Jul,Jun,May,Apr,Mar,Feb & Jan Should Select & So on...

can you give me an exmple on this..

Re: selection in Month?

its_anandrjs — Mon, 15 Dec 2014 08:34:57 GMT

Hi,

This expression works for single selection only like Mar then you get Jan,Feb,Mar or see this example

Let varMaxDate = Num(now());

Let varMinDate = Num(AddMonths( now(), -12));

LOAD

($(varMinDate) + IterNo() -1) as NumTimeStamp,

Timestamp($(varMinDate) + IterNo() -1)*12*60 as TimeStamp,

Date($(varMinDate) + IterNo() -1) as Date,

Month(Date($(varMinDate) + IterNo() -1)) as Month

AutoGenerate 1 While ($(varMinDate) + IterNo() -1) <= $(varMaxDate);

And add the List box with expression

=if(Month <= Max(TOTAL Month) ,Month)

Regards
Anand

Re: selection in Month?

preminqlik — Mon, 15 Dec 2014 08:40:33 GMT

in above srinivas statement small correction.. try below one.

=sum({<Month=,Year=,Day=,Date=,YearOfOrder=, WeekOfOrder=, DayOfOrder=,

OrderDate={">=$(=Num(YearStart(Max(MonthOfOrder))))

<=$(=Max(OrderDate))"}>} sales)

Re: selection in Month?

tyagishaila — Mon, 15 Dec 2014 08:47:52 GMT

What is IterNo()

Re: selection in Month?

its_anandrjs — Mon, 15 Dec 2014 08:50:42 GMT

Hi,

This is for example all load is the example. You have to use only this expression in any list box but it works well if date field is pure date format.

=if(Month <= Max(TOTAL Month) ,Month)

Regards

Anand

Re: selection in Month?

Tue, 16 Dec 2014 06:19:02 GMT

Hi Kacy,

Or you can do one thing.

set bookmarks for the selections that you want at a purticular time.

now make a inline and use it with the bookmarks that you made

and pick up that bookmark in a list box.

by that way .if you select Feb (i.e is a bookmark for jan and feb),it will give you selection for jan and feb and likewise.

in this case u need to make 12 bookmarks for twelve months.

in inline you need to take bookmark name(Jan,Feb,Mar and so on....) and BMId(BM01,BM02...and so on)

here if you select Feb...it will take BM02.that bookmark is for jan and feb selection.

I guess this can help you.

Thanks

Sudhanshu Shrivas

Re: selection in Month?

Tue, 16 Dec 2014 06:41:52 GMT

I recommend the approach given by Prem Kumar.

Re: selection in Month?

Tue, 16 Dec 2014 06:53:36 GMT

How to get ,YearOfOrder=, WeekOfOrder=, DayOfOrder=, MonthOfOrder ...

Re: selection in Month?

Tue, 16 Dec 2014 06:56:17 GMT

hi,

Its can be diffrent in your case

i just gave example with my data.

it could be year month and weekin your data ...so use as per your dat

Thanks

sudhanshu shrivas

Re: selection in Month?

Tue, 16 Dec 2014 07:20:57 GMT

Hi Shrivas,

I didn't find any attachment...

Re: selection in Month?

Tue, 16 Dec 2014 07:39:28 GMT

Please refer the attached Qlikview applications ..

Hope the 2 different approaches in the 2 samples help you.