Getting the detailed record set for month selected

[#1]

My requirement is as follows:

Initially only Table 1 is displayed and Table 2 is hidden.

Table 1:

Month	Total Sales
Jan	1200
Feb	2000
March	2500
April	1000
May	5200

On selecting 'Jan' following table needs to be displayed which is the detailed record set for January itself and Table 1 must be hidden on selection.

Table 2:

Month	Date	Country	Total Sales
Jan	5/1/2016	USA	200
Jan	10/1/2016	IND	800
Jan	30/1/2016	UK	200

[kaushiknsolanki · Accepted solution]

Hi,

You can use the QlikView Variable to show and hide the charts.

Have a look at the link below.

QlikView App: Show and Hide Windows Dynamically

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik Solanki. Show/Hide is fine, now in order to link Table 1 and Table 2 on the basis of month selected what approach is needed?

[MayilVahanan]

HI

For Table1:

Layout Condition is GetSelectedCount(MonthFieldName) = 0

For Table2:

Layout Condition is  GetSelectedCount(MonthFieldName) <> 0

[saimahasan]

You can use conditional statement on table2 and write the expression as

=If(GetSelectedCount(Month)>0,1,0).

This will cause Table2 to get displayed only if a value is selected in Month field otherwise Table2 will be hidden.

[kaushiknsolanki]

Hi,

What do you mean by linking? If you mean that you have 2 excel and you want to link them using Month then Alice both the field as same name. When QlikView find same name across 2 tables, it will join by default.

Regards,

Kaushik Solanki