topic Hide & Show objects based on selection in straight table fields in QlikView

Hide & Show objects based on selection in straight table fields

Mon, 06 Jul 2015 04:21:32 GMT

For example i have a straight table...if i select first 10 rows in the table it should show pie chart...and if i select another 5 it should show bar chart...and if i select another 7 rows it should show line chart like wise....

I add my QVW file ...in that Barchart &straight tables are there....if i select any field value in customerID<=10...then barchart should appear....if select customerID >=10...barchart should hide&another chart should appear...this is the task friends

Re: Hide & Show objects based on selection in straight table fields

jagan — Mon, 06 Jul 2015 04:37:38 GMT

Hi Naveen,

If you select in a Straight table it will select in a Field and you can get the count of that by using

=GetSelectedCount(FieldName)

You will get the count of the selected values in that field, but there will be no function to return that you selected first 10 rows, in background if you have a key fields with 1 to 10 for this values then it is doable. If you attach the sample file and your required output then it would be easier.

Regards,

Jagan.

Re: Hide & Show objects based on selection in straight table fields

Anonymous — Mon, 06 Jul 2015 04:38:15 GMT

You can use getselectedcount() function in the layout tab of the pie/bar/line chart.

Re: Hide & Show objects based on selection in straight table fields

Tue, 07 Jul 2015 05:12:32 GMT

I Got it friends........... !

in layout ....show...condition

=if(getselectedcount(CustomerID) = 1 and CustomerID <= 10, 1, 0)