topic Re: Conditional Hide /Show line charts in QlikView

Conditional Hide /Show line charts

Sat, 21 Sep 2013 15:28:44 GMT

Hi,

I've created the condition in Properties ----> "Layout tab"

=(REGION_NM='AMS' or GetSelectedCount(REGION_NM)=0) and GetSelectedCount([Quarter FY])=0

if end user wants select SUB_REGION_NM filter then the associated REGION_NM chart should diplay, but the above expression display when ever end user selects region 'AMS' in REGION_NM filter it get selected and display and are so many SUB_REGION_NM names are available for each REGION_NM like 'AMS' , 'EMEA' and 'APJ' but we can't hard code like above expressions

I need to add SUB_REGION_NM in the expression and it takes dinamically whenever SUB_REGION_NM are selected in filter correponding charts should diplay and remaining charts are Hide.

Thanks in advance,

Ram.

Re: Conditional Hide /Show line charts

qlikpahadi07 — Sun, 22 Sep 2013 10:49:00 GMT

Hi Ramana,

use only GetSelectedCount(SUB_REGION_NM)

this function will return number of selection, this might help you

Re: Conditional Hide /Show line charts

Mon, 23 Sep 2013 05:04:28 GMT

Hi Rohi,

if i select the field value in Region filter value as AMS and Sub_Region filter value as US this time conditional show of the charts are working, but when ever we select the sub_region filtere value as US and corresponding AMS region filter value should get select and AMS region line charts sholu be display in sheet remaining charts going to hide.

Regards,

Ram.

Re: Conditional Hide /Show line charts

qlikpahadi07 — Mon, 23 Sep 2013 08:29:21 GMT

was that helpful ?

Re: Conditional Hide /Show line charts

qlikpahadi07 — Mon, 23 Sep 2013 09:15:16 GMT

Hi Ramana,

could you attach a sample will be helpful