topic Re: set analysis problems in QlikView

set analysis problems

Wed, 05 Dec 2012 11:02:34 GMT

Hi i have a pivot table and I am trying to calculate how many products of one brand i have in stock. ok...i can set a timerange for this with a slide bar. what I have selected is the 21.10.2012-18.11.2012.

and my chart looks like this:

brand 1.stock 1.Date LastDate

asdf 452 21.10.2012 18.11.2012

aqwe 0 28.10.2012 18.11.2012

so for the brand aqwe I dont want the 0 to be shown I want the 1.stock from the 28.10.2012 to be shown. so my expression looks like this: sum({<#Date = {'$(=min(#Date))'}>}#Stock). why does aqwe shows a first stock even though on the 28.10.2012 i had a stock from 770??? if is obviously using the 21.10.2012 as min(#Date) in set analysis. Can someone help me to fix this problem?????

regards,

Re: set analysis problems

Wed, 05 Dec 2012 11:03:17 GMT

oh and i forgot the expression for 1.Date is min(#Date) and for LastDate it is max(#Date)

Re: set analysis problems

Wed, 05 Dec 2012 11:25:04 GMT

Can u post a sample file?

TMF

Re: set analysis problems

Wed, 05 Dec 2012 11:29:39 GMT

sry I can't these are sensitiv data I'm using

Re: set analysis problems

Wed, 05 Dec 2012 11:34:28 GMT

I understand...

You can post a sample file with few records (create a new DB with few records) just for try to help you, if you want.

TMF

Re: set analysis problems

Thu, 06 Dec 2012 10:19:42 GMT

I finally got the time to create some sample data

regards,

Re: set analysis problems

Mon, 10 Dec 2012 09:00:50 GMT

can someone please help me with this problem! Im not able to find a solution by myself...any kind of help is appriciated.

regards,

Re: set analysis problems

Tue, 11 Dec 2012 07:47:35 GMT

can still no one tell me how to solve this?