Quarter and previous Quarter Comparison and growth

[Qlik__Vinodh]

Hi freinds,

i have an issue in current-quarter and previous year quarter comparisions.so pls help me out.

i have an fieds Financialyear,FinancialMonth, Datefiled.

[perumal_41]

Hi.

Please upload ur application .i help to u

[Qlik__Vinodh]

Hi perumal ,

application size is too large yar

Can u give me a sample application

[manideep78]

Can you  please give sample data to understand your requirement??

[SunilChauhan]

calculate quarter

in script

ceil(Month(FinancialMonth)/3) as Finquarter

in Expressions

Current qurter:

sum({<Finquarter={$(=max(

{<Financialyear={$(=Max(Financialyear))}>}Finquarter))}>}Amount)

Previous Quarter:

sum({<Finquarter={$(=max(

{<Financialyear={$(=Max(Financialyear))}>}Finquarter)-1)}>}Amount)

Hope this helps

[Qlik__Vinodh]

Hi Manideep,

if u have sample one send me the appication yar

[Qlik__Vinodh]

Hi luminary,

if u have sample one provide me the application .

[perumal_41]

Hi,

only load 10000 record  and upload qvw application .