topic Re: Set analysis in QlikView

Set Analysis, To Display All Years

nihhalmca — Wed, 06 Nov 2013 08:18:10 GMT

Hi All,

My requirement is when user click year 2012 he want to see 2008 data(sales) in straight table for this i wrote exp: Sum ({$<Year={$(=(Year)-4)}>}Sales)

this is working fine but user wants with out selecting year he wants to show all years data in Straight table

Please i need your assistance

Thanks in Advance

Nihhal

Re: Set analysis

Wed, 06 Nov 2013 08:22:29 GMT

try

if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))

Re: Set analysis

senpradip007 — Wed, 06 Nov 2013 08:24:51 GMT

Could you upload a sample application ?

Re: Set analysis

salto — Wed, 06 Nov 2013 08:35:29 GMT

Hi,

create a chart with Year as the dimension and =Sum (Sales) as the expression.

Hope this helps.

Re: Set Analysis, To Display All Years

nihhalmca — Thu, 27 Feb 2014 06:07:58 GMT

Thank You Alexis Tan

NiHhal.