Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter year, half-year, quarter, month

Hi Qlikview Experts,

I have a chart to display the sales trending.

I have also created a list box with the period - 'Year', 'Half Year', 'Quarter' and 'Month'.

However, the problem I am facing now is that whenever I try to filter out data based on 'Half Year' period, the chart will display both 'Half-Year' and 'Year' data (see image 2).

If i were to remove 'Year' from my chart dimensions, the 'Half-Year' period will be displayed out nicely in my chart (see image 3).

I have also included dimension conditional "=SubStringCount(concat (Period, '|'), 'Half Year')" for each of the dimensions and changed accordingly,

What i am trying to achieve is to include both 'Half Year' and 'Year' as options for my user to select so that they can view the chart in their preferred way (i.e to display chart like image 1 or image 3 when the specific period is selected respectively).


The chart above is when 'Year' is selected.


The chart above is when 'Half Year' is selected.

image001 (1).png

The chart above is when i removed 'Year' from the Dimension list and retained 'Half Year', then the chart would display as what i want.

0 Replies