topic Re: set analysis in QlikView

set analysis

rathnam_qv — Wed, 06 Nov 2013 05:57:40 GMT

Hi all,

i have goal metric in my straight table which shows data for 12 months...but i want to display it for jan to sep

how can we achieve this can any one help me..

Thanks in advance!!!

Smiley

Re: set analysis

sadickbasha — Wed, 06 Nov 2013 07:04:20 GMT

Hope below expression helps

=Sum({$<Month={Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep}>} Goal_Metric)

Re: set analysis

Anonymous — Wed, 06 Nov 2013 07:06:35 GMT

Hi Rathnam

If you are using QV11, you can do it with the dimension limits options.

Go to your straight table properties, then to Dimension Limits and finally choose "Show only", "first", "9" values on your period dimension (10 if you want to show the last three months with the "Show Others" option.

Quentin

Re: set analysis

rathnam_qv — Wed, 06 Nov 2013 09:29:57 GMT

Hi Sadick,

if i use this..it is giving me the total amount for all months Jan to Sep..but it is not giving me individual month value

Re: set analysis

sadickbasha — Wed, 06 Nov 2013 09:33:02 GMT

Try with Quentin's solution, using Dimension limits you can limit to only 9 rows

Re: set analysis

Wed, 06 Nov 2013 09:38:07 GMT

in the Dimension change [Month] to If( Month >= 9 AND Month <= 11, Month, NULL())

Check "Suppress When Value is Null"

Re: set analysis

rathnam_qv — Wed, 06 Nov 2013 09:41:31 GMT

Hi Sharon,

Month is not my dimension its a filter

Re: set analysis

Wed, 06 Nov 2013 09:49:38 GMT

hmm.... can you attach a example??

Re: set analysis

Wed, 06 Nov 2013 10:06:18 GMT

You should have a dimension with months otherwise you should make one for each month