Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vinodh_qlikview
New Contributor

Quarter and previous Quarter Comparison and growth

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.

7 Replies
perumal_41
Valued Contributor II

Re: Quarter and previous Quarter Comparison and growth

Hi.

Please upload ur application .i help to u

vinodh_qlikview
New Contributor

Re: Quarter and previous Quarter Comparison and growth

Hi perumal ,

application size is too large yar

Can u give me a sample application

manideep78
Valued Contributor

Re: Quarter and previous Quarter Comparison and growth

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

chauhans85
Esteemed Contributor

Re: Quarter and previous Quarter Comparison and growth

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

vinodh_qlikview
New Contributor

Re: Quarter and previous Quarter Comparison and growth

Hi Manideep,

if u have sample one send me the appication yar

vinodh_qlikview
New Contributor

Re: Quarter and previous Quarter Comparison and growth

Hi luminary,

if u have sample one provide me the application .

perumal_41
Valued Contributor II

Re: Quarter and previous Quarter Comparison and growth

Hi,

only load 10000 record  and upload qvw application .

Community Browser