Template In qlikview

[Anonymous]

Hello Everyone.

I want to know how to create template in qlikview like below.

[Anil_Babu_Samineni]

Every thing is possible?

=If(GetFieldSelections(Year) >0, FirstSortedValue(Category, Aggr(Sum(Sales), Category),1) & ' had sold ' & Avg(Sales) & ' more than last year', '')

[Anonymous]

i want show different template for different selection. then what should i do

[Anil_Babu_Samineni]

Why not using this?

Different Temp1

=If(GetFieldSelections(Year) >0, FirstSortedValue(Category, Aggr(Sum(Sales), Category),2) & ' had sold ' & Sum(Sales) & ' more than last year', '')

Different Temp2

=If(GetFieldSelections(Year) >0, FirstSortedValue(Category, Aggr(Sum(Sales), Category),3) & ' had sold ' & Count(Sales) & ' more than last year', '')

Different Temp3

=If(GetFieldSelections(Year) >0, FirstSortedValue(Category, Aggr(Sum(Sales), Category),4) & ' had sold ' & Fractile(Sales, 0.09) & ' more than last year', '')

And so on...

[Anonymous]

in a single object?

[Anil_Babu_Samineni]

I don't know where you are presenting. I am just replying for below one. That means, Obviously different objects only.

i want show different template for different selection. then what should i do

Re: Template In qlikview

But, To present in single you just use Chr(10) to break into next line the same