Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Help with show/hide columns of a straight table.

Hello all,

I have a QVW where I have some amount for every quarter for every branch. I want to display the columns according to the selections in Qtr field. If I select 1 in Qtr, I need only sum(amount) for qtr1. If I select both 1 & 2, I need two columns for Qtr1 and Qtr2. Could any one please help me out. I tried substringcount but even when I clear all selections the columns do show up in the table. Please find the attached QVW.

Thanks in advance!

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Hi, OK, see this example

View solution in original post

4 Replies
Highlighted
Master II
Master II

See this example for the Column Q1

Highlighted
Creator III
Creator III

Thank you for the quick response. But if no selection is made in 'view' list box, we still have the column for Q1 without values. I want to hide the column completely and show it only when I select 1 from Qtr. It should be shown even when I make multiple selections including 1.

Highlighted
Master II
Master II

Hi, OK, see this example

View solution in original post

Highlighted
Creator III
Creator III

Thank you!!