Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Fareeha123
Contributor II
Contributor II
‎2025-06-27 12:14 PM

Dynamic Row

Hi, I have a requirement to show and hide row with subtotals in qlik table dynamically. 

Straight table with 5 columns and total. If user selects Umbrella Name as a filter than Umbrella Names should show on the table grouped with their ID/funds and subtotal line.  If it is not selected that it show straight table with Overall total. 

Please let me know how this can be achieved dynamically. 

Attaching the screenshot for example. 

Labels (1)
Labels
Preview file
149 KB
242 Views
1 Reply
rubenmarin
MVP
MVP
‎2025-06-28 01:25 AM

Hi, I'm not sure of hte requeriments, but if it helps as hint: maybe you can add 2 times the dimension, and use the 'show if condition'.

One will have the condition: "Count(Distinct Umbrella)>1" and the totals enabled.

The other will have the condition: "Count(Distinct Umbrella)=1" and the totals disabled.

210 Views