Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide & Show objects based on selection in straight table fields

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

1 Solution

Accepted Solutions
Not applicable
Author

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

in layout ....show...condition

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

View solution in original post

3 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author


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

Not applicable
Author

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

in layout ....show...condition

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