Conditional Hide /Show line charts

[#1]

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.

[qlikpahadi07]

Hi Ramana,

use only  GetSelectedCount(SUB_REGION_NM)

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

[#3]

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.

[qlikpahadi07]

was that helpful ?

[qlikpahadi07]

Hi Ramana,

could you attach a sample will be helpful