topic Re: Set Analysis in QlikView

Set Analysis

Tue, 08 Jan 2013 06:51:13 GMT

Dear Communty

This is my Requirement

i want three months comparision

that is

current year max month by default monthend last year current month

Table
Sector / Product / Rating	Current month max year		finanacial year end that means march		current month previous year
Sector / Product / Rating	Amt	% of Total	Amt	% of Total	Amt	% of Total
Erg
Tel
Trn
Oth
Total

Table
Sector / Product / Rating	Jun 12		Mar 12		Jun 11
Sector / Product / Rating	Amt	% of Total	Amt	% of Total	Amt	% of Total
Erg
Tel
Trn
Oth
Total

Re: Set Analysis

sujeetsingh — Tue, 08 Jan 2013 07:09:47 GMT

its all unclear??

Re: Set Analysis

Tue, 08 Jan 2013 07:19:14 GMT

Hai

I need 3 months comparision

that

current month current year end of the financial month and last year current month

its dynamic selection should change

how i get this one

Re: Set Analysis

Tue, 08 Jan 2013 08:08:11 GMT

Hi Ram,

Create 3vars one is for currentmonth, current year, Fiscal Month

ForCurrent month year= $(vCurrentmonth)'-'&$(vCurrentyear)

For lastyear currentmonth= $(vCurrentmonth)'-'&$(vCurrentyear)-1

For Fiscalmonth= if fiscal month is equal to previousmonth then use $(vCurrentmonth)-1 else if it is equal to forwardmonth then use $(vCurrentmonth)+1

note: current montnh and year will take current selections..

chandra

Re: Set Analysis

Tue, 08 Jan 2013 08:21:03 GMT

hai pls find the attachment

Re: Set Analysis

Tue, 08 Jan 2013 09:38:18 GMT

Hi Ram,

Created table chart under Sheet8 and i used normalyear if you want fiscal year replace normal year with fiscal year.. i don't know the formula for Total but you can able to write the total formula based set functions..

Regarding Alignment create inline table like

load * inline [

Dim

Amount

Total%

];

use Dim as dimension and write expression for Amount like

=sum({<Month={'Mar'},Year={$(NORMALMAXYR),Dim={Amount}>}AmountF)

Try this..

Re: Set Analysis

Tue, 08 Jan 2013 10:11:55 GMT

hai

2012 nov 2012mar 2011nov

this structure iwant suppose if i select 2011

then it should change 2011 nov 2011 mar 201o nov

how i can do this thing