Navigate to different sheet on clicking on value coming out of expression

[saumyashah90]

Suppose

Sheet2-> Sheet Object Id(SH02) has a chart

having data

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
1a	1b	135	23	95874562365455	abcdef
2a	2b	145	32	73245354678678	ghijklm
3a	3b	234	11	78675678678678	opqr

sheet1-> Sheet Object Id(SH01)  has a chart

Header 8	Header 9	Header 10	Header 11
x	y	1	4
z	b	3	5

Header 3 is value of expression -> Count( Distinct FieldA)

Header 4 is value of expression -> Count(Distinct FieldB)

i want

If i click on 135(from Header3) -> it should navigate to Sheet1 with all related data to it

similarly for 23(from Header4)-> it should navigate to Sheet1 with all related data to it

Remember -> Only on clicking Header3 and Header4 values it should navigate to Sheet1 not others.

[saumyashah90]

any one

[#3]

Hey Saumya,

When you click on an expression value you will be actually selecting the dimensions in that row. In this case if you click 135 or 23 you will be selecting 1a and 1b and you will can see them in current selection box.

You can use Document Properties > Triggers >Field Event Triggers to switch sheets

Hope it was helpful

Thanks

AJ

[Colin-Albert]

You can achieve something like this by having the two charts on the same sheet and conditionally hiding the drill-down chart (sheet 1 chart). This will work provided the data values in one of your dimension fields are unique.

Lets call the sheet1 chart CH01, and the sheet2 chart CH02, and put them on the same sheet.

On CH02, when you click on 145 Header3 or 23 in Header4 you are selecting those dimension values - this is standard QlikView functionality.

Set the show condition on CH01 to be  UniqueDim= only(UniqueDim)  where UniqueDim is a dimension that defines a unique row in CH02.

Now CH02 will only be visible when CH01 only has 1 row selected.

You can add a button to go BACK or CLEAR to clear this selection and hide CH01 again.

I hope this makes sense!