topic Button to select one or all in QlikView

Button to select one or all

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

I have a dimension called month, where “Jan, Feb, Mar…Dec” is stored, where I want to give use to select one of the months (and the default will be always current month). On top of that I also want to give the user to select either current month only or YTD (which means to select all the previous months). Any idea on how to implement this? Many thanks

Re: Button to select one or all

prat1507 — Tue, 03 Oct 2017 07:39:28 GMT

Hi Please use this

Tab1:

LOAD * inline [

Months

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

Let v_currMth=Month(Today());

Tab2:

LOAD * inline [

Status, Months

Curr, $(v_currMth)

];

Tab3:

Load 'YTD' as Status,* Resident Tab1

where date(month(date#(Months,'MMM')) )<= date(Month(Today()));

Create a listbox with Status and use.

Regards
Pratyush

Re: Button to select one or all

ronaldwang — Wed, 04 Oct 2017 06:08:36 GMT

thanks Pratyush, it is nice