Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selection in Month?

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

15 Replies
Not applicable
Author

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

Not applicable
Author

I recommend the approach given by Prem Kumar.

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Hi Shrivas,

I didn't find any attachment...

Not applicable
Author

Please refer the attached Qlikview applications ..

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