topic hie in QlikView

hie

Tue, 03 Apr 2012 05:31:59 GMT

i want to show my data of only 2 quarter from max date i.e if i select date 3rd april 2012 den my chart must show of data april marc feb jan dec nov what to do ??

hie

CELAMBARASAN — Tue, 03 Apr 2012 05:41:31 GMT

Hi,

Sum({<DateField={">=$(QuarterStart(Max(DateField),-1))<=$(Max(DateField))"},YearField=,MonthField,DayField=>} Sales)

Sum({<DateField={">=$(MonthStart(Max(DateField),-5))<=$(Max(DateField))"},YearField=,MonthField,DayField=>} Sales)

Celambarasan

hie

Tue, 03 Apr 2012 06:07:27 GMT

it is showing no data to display.. y so??

hie

Tue, 03 Apr 2012 06:08:57 GMT

actual i want to do thru variable in which user can give any date..........

hie

CELAMBARASAN — Tue, 03 Apr 2012 06:32:08 GMT

Hi,

Check with this here VariableDate is your date variable but make sure it is in correct date format otherwise change it to Date(Date#(VariableDate,'DD/MM/YYYY')) here 'DD/MM/YYYY' is the entered date format.

Sum({<DateField={">=$(QuarterStart($(VariableDate),-1))<=$(VariableDate)"},YearField=,MonthField=,DayField=>} Sales)

Re: hie

Tue, 03 Apr 2012 09:32:44 GMT

Hi Sumita,

Please find the attached file.

Hope this will help you.

Regards,

Kushal

Re: hie

Tue, 03 Apr 2012 10:05:43 GMT

hi kushal,

can u please help me in that i have datefield nd date is present in MAY-10,JUN-10 like that i want to do set analysis that when i click jun 10 then it show sale of may10

my expressn is sum({$<datefield={$(=only(period)-1}>}sale)

prblm is that date in text format so it is not showng corrct output what should i do

Regards

Sumita

hie

Tue, 03 Apr 2012 10:08:32 GMT

Hi Sumita,

Please clarify what exactly you want regarding previous 2 quarter :

If you select 01-04-2012 then you should get output as last six months from that or

if your fiscal year starts from april and your quarter 1 is april-may-jun then

previous 2 quarter will be months april may jun of 2012 and jan feb mar 0f 2012 including the quarter of the date that you have inputed.

hie

Tue, 03 Apr 2012 10:16:53 GMT

yes exactly this i wnat in my chart current nd preceding quarter..............

bt frst plz help me

that i have datefield nd date is present in MAY-10,JUN-10 like that i want to do set analysis that when i click jun 10 then it show sale of may10

my expressn is sum({$<datefield={$(=only(period)-1}>}sale)

prblm is that date in text format so it is not showng corrct output what should i do

hie

Tue, 03 Apr 2012 10:29:20 GMT

Hi Sumita,

apply

date#(Date,'MMM-YY'')

to the date field,it will be converted from text to date

Re: hie

Tue, 03 Apr 2012 11:19:35 GMT

Hi Sumita,

Please find the attached qvw,may be this is what you want.

Re: hie

Tue, 03 Apr 2012 12:11:46 GMT

Hi Sumita,

U can use this expression

=sum({$<Period ={"$(=date(addmonths(max(Period),-1),'MMM-YY'))"}>}Sale)

Regards,

Kushal

Re: hie

Tue, 03 Apr 2012 12:33:46 GMT

Thanks.....