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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

list box not reflecting the changes

 

HI All,
I have implemented a pivot table with accumulation expression

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

If i don't make any product selection then i have all the week start dates displayed properly.
But when i make a product selection then i have missing of weeks . as shown in the figure and screenshot attachment.
Can someone please help me with this to display all the weeks irrespective of my product selections.

Thanks in advance.

Labels (1)
12 Replies
sunny_talwar

Would you be able to share a sample where we can see the issue?

smilingjohn
Specialist
Specialist
Author

Sorry 2015 is a typo error, it is showing the data after 2010 ,

But my year selection is not working ,

If I select 2019 from year list box then it should show weeks data from 2019  onward which is not working now .

It is showing the data from  > 2010 onwards  irrespective of year selection

Need your help on this 

Brett_Bleess
Former Employee
Former Employee

Hey John, any chance you can attach the QVW for this one, or a sample of one that shows the issue?  I agree with Sunny, I think that is going to be necessary in order for anyone to try to work on it further, as it would seem there may be something going on in your data model potentially...  If you have confidential info in the app, you could scramble those fields provided they are not ones we need to be able to trace, you can do that via the Desktop Client in the Settings\Document Properties\Scrambling tab...

Regards,
Brett

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.