topic Re: List Object Data hiding in QlikView

List Object Data hiding

Mon, 29 Jun 2015 10:11:53 GMT

Hi All,

I have two filters 1)Month----All Month names.

2)Yeartodate---Having YTD, MTD as Values

My requirement is i have to show both YTD& MTD only when any month selected in Month filter. other wise i have to display only YTD in Yeartodate filter.

Please help me in this regard.

Thanks,

Nani

Re: List Object Data hiding

buzzy996 — Mon, 29 Jun 2015 10:19:28 GMT

u can try,

on ur seconde filtr Yeartodate--list box field expression---something like tis,

if(getfieldselections(month)={list ur month names} ,'Yeartodate','only ytd(do sometyhing for this to get only ytd values)')

Re: List Object Data hiding

Mon, 29 Jun 2015 10:23:06 GMT

Hi Shiva,

With this expression can we get MTD ?

Re: List Object Data hiding

buzzy996 — Mon, 29 Jun 2015 10:26:11 GMT

i think u need ytd,this case right?

sample,but expression will vary accordingly ur needs,

YTD Sales:

SUM({<DateDimensionName = {'>=$(=YearStart(Today())) <= $(=Today())'}>} MeasureName)

MTD Sales:

SUM({$<DateDimensionName = {'>=$(=MonthStart(Today())) <= $(=Today())}>}MeasureName)

Re: List Object Data hiding

Mon, 29 Jun 2015 10:28:02 GMT

shiva,

let me clarify you that i just need to show /hide the values of a list object based on the selection from the other list object.

Thanks,

Nani

Re: List Object Data hiding

Mon, 29 Jun 2015 10:31:54 GMT

Try this one

Re: List Object Data hiding

settu_periasamy — Mon, 29 Jun 2015 10:34:47 GMT

Hi,

try to use the condition layout.

like YTD List Box -> Layout -> Conditonal

put =GetSelectedCount(Month)

Re: List Object Data hiding

buzzy996 — Mon, 29 Jun 2015 10:41:59 GMT

yes,ur right..for that purpose only i given expression on my first comment..if u select some values on ur month field "getfieldselections(month)={list ur month names}" then it'll show automatically corresponding values on ur second filter.