topic Re: hi in QlikView

hi

Mon, 26 Jan 2026 18:19:17 GMT

i have to give a filter of a month and year only...that is if selects a year that is 2012 then he can click on either a year or a month to show him monthwise sales of 2012 or yearly sales of 2012

Re: hi

Tue, 25 Mar 2014 05:26:01 GMT

Hi,

it can be done by tree view list box aur using multibox also.

PFA

Re: hi

Tue, 25 Mar 2014 05:32:16 GMT

this is not a option as i want to select a year first then i am having only two options either to click on year or month...so that i can see monthly or yearly sales of that particular year that i selected

Re: hi

Tue, 25 Mar 2014 06:01:46 GMT

Hi Sanchit, You can have a drop down of Year and Month in a list box with "Always select one value" enabled.

use a inline table for this.

e.g.

Dimensions:

load * inline

[

Dimname

Year

Month

];

In your chart have your year and month dimensions, but enable Conditional. and then have a condition like this.

SubstringCount(Dimname,'Year') > 0 in your year dimension

and

SubstringCount(Dimname,'Month')>0 in your month dimension

and well that should be it.

Thanks,

Ram

Re: hi

qlikpahadi07 — Tue, 25 Mar 2014 08:13:18 GMT

Hi Sanchit,

a bit confused if you select Year first that means you are interested in that particular year then obvious you will go for months...

why you want first Year option then again Year and Month Option.

if i select 2012 among 2006 - 2012.

Months options which I should get : Jan, Feb & Mar

Years options which YOU want ???? it obvious will be 2012 isn't it ?

Re: hi

Tue, 25 Mar 2014 08:16:22 GMT

Can you add a sample file with small data?