topic Re: Set analysis in QlikView

Set analysis

Thu, 27 Feb 2014 16:39:36 GMT

How can I restrict the data shown on a straight table by only showing the last 6 weeks of data? I need to retain the data in the file though to display it on another chart in the same file, so it can't be specified in the load.

I have a calculated column, with the formula

PRICE*NOMINAL/100

I tried this

{$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100

but i get the error message 'Garbage after expression "$" '

help!

Re: Set analysis

Thu, 27 Feb 2014 16:43:08 GMT

Can dimension limits be used for this purpose? If so, how?

Re: Set analysis

tresB — Thu, 27 Feb 2014 16:44:24 GMT

You missed an angular bracket.

Try like :

Sum ( {$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100)

Re: Set analysis

Anonymous — Thu, 27 Feb 2014 16:44:42 GMT

There is no expression here. Try

sum({$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100)

Re: Set analysis

santharubban — Thu, 27 Feb 2014 16:45:44 GMT

try this

{$<WeeksAgo={'>=1'},WeeksAgo={'<7'}>}PRICE*NOMINAL/100

{$<WeeksAgo={">=1"},WeeksAgo={"<7"}>}PRICE*NOMINAL/100

Re: Set analysis

Thu, 27 Feb 2014 16:48:51 GMT

Thanks everyone

Where would I be without the community?!