Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

List box

Hi Expertise

I am using the below expression  in my pivot table to display the weekly data . and this is a running total  And I am using this part in my expression (Sum({1<Year *= {">2015"}>}0), 0) to populate the missing weeks so that I will be dipsplaying all the weeks  and the result is accurate



The only problem I am facing is that  the data is is diplaying from 2016 onwards , and if I select Year=2019 it doesn’t  change.


The table should show the weekly data according to my Year list box selection .Can you please help me on this .

I got have fixed this using possible values . 


Thanks in Advance

4 Replies

The '1' ignores all selections, so the intersection is between everything and 2015, and your selection will not be considered. What goes wrong if you remove the '1' (or replace with '$')?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator III
Creator III

Hi Jonty Thanks for the reply , 

If i replace 1 with $ or nothing then upon selecting year 2019 , it shows me only the weekly dates where there is data . 

but i need to see all the weekly dates within it thats the reason i  used 1. 

I want to display all the week with list box selection . Please loo at the attachment





Creator III
Creator III

Any Help on this ?

Support (Former)
Support (Former)

John, have a look at the following Design Blog post and I am including the base URL after that in case you want to do some further searching:



You will need to use an expression in the set analysis instead of the year value in this case that ties to the list box etc...  



To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.