topic Re: Week in QlikView

list box not reflecting the changes

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Week

sunny_talwar — Wed, 20 Nov 2019 13:36:53 GMT

Can you try this

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

Re: Week

smilingjohn — Thu, 21 Nov 2019 04:12:12 GMT

Thanks for the reply Sunny,

When used this change definitely it is populating the missing week dates but with extra column of zero's and when i tried suppressing the null values it is showing again the same result of missing dates . please see the attachment

Do i need to make any change?

Re: Week

sunny_talwar — Wed, 20 Nov 2019 14:32:10 GMT

You might be able to suppress one of the two dimensions, but if won't work if you suppress both... this is just a limitation of the tool. I have not been able to find a solution to this problem yet.

Re: Week

smilingjohn — Wed, 20 Nov 2019 14:33:13 GMT

Hi sunny but thing in this is that , the started to populate from 2001 . The condition of set analysis to show th data after 2010 is not working .

Re: Week

smilingjohn — Wed, 20 Nov 2019 14:36:04 GMT

And also the selections are not working , like I am trying to select 2019 from year list box ,but still there is no change in this ...but still the report is showing the data from 2001

Re: Week

sunny_talwar — Wed, 20 Nov 2019 14:49:23 GMT

Try this

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

Re: Week

smilingjohn — Wed, 20 Nov 2019 14:55:48 GMT

Thanks sunny now I see the data from 2010 onwards but still the year filter is not working on this , after selecting year 2019 the report still shows the data from 2015 onwards .

Thanks

Re: Week

sunny_talwar — Wed, 20 Nov 2019 15:07:11 GMT

That is strange that it only shows after 2015... and not 2010? Would you know why that might be?

Re: Week

smilingjohn — Wed, 20 Nov 2019 15:19:08 GMT

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 which is not working now .

Need your help on this

Re: Week

sunny_talwar — Wed, 20 Nov 2019 15:25:40 GMT

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

Re: Week

smilingjohn — Wed, 20 Nov 2019 15:53:29 GMT

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

Re: Week

Brett_Bleess — Wed, 04 Dec 2019 18:45:22 GMT

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