topic Re: Template In qlikview in QlikView

Template In qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone.

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

Re: Template In qlikview

Chanty4u — Tue, 19 Dec 2017 07:43:03 GMT

am not sure but you can try this

concatenate four fields in script -- as a one filed

and write the below expression in text object

sample:

LOAD Product,

Category,

Type,

Sales,

Region,

Product&','&Category&','&Type as New

=concat(New,',')

Re: Template In qlikview

stabben23 — Tue, 19 Dec 2017 07:58:27 GMT

You coulod use a textbox. Add Expression ='Product ' & "Product Name" & ' Purchase By ' &"Customer Name".

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 08:27:24 GMT

i don't want to used concat.

Re: Template In qlikview

Anil_Babu_Samineni — Tue, 19 Dec 2017 08:50:07 GMT

If technology having two sub values then how you want to see in template?

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 11:10:26 GMT

my actual requirement is,suppose i have two list box year and category.

While i click on year(only one can select) it will show the status(in multiple character) of car or trucks of that year

Re: Template In qlikview

Chanty4u — Tue, 19 Dec 2017 11:12:45 GMT

try this

=If(GetSelectedCount(Year) > 0, Concat(Distinct Category,',))

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 11:19:43 GMT

something is wrong there

Re: Template In qlikview

Chanty4u — Tue, 19 Dec 2017 11:31:50 GMT

check now

load * Inline [

Categ ,Year

Car,2014

van,2014

Car,2010

van,2017

Car,2000

];

exp: =If(GetSelectedCount(Year)> 0, Concat(Distinct Categ,','))

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 11:48:27 GMT

i want to show like while i click on year 2011 it will show template like " trucks had sold 50% more than last year" i don't want to used concat.

Re: Template In qlikview

Anil_Babu_Samineni — Tue, 19 Dec 2017 11:53:37 GMT

Every thing is possible?

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

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 12:06:30 GMT

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

Re: Template In qlikview

Anil_Babu_Samineni — Tue, 19 Dec 2017 12:36:14 GMT

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...

Re: Template In qlikview

Anonymous — Tue, 19 Dec 2017 12:49:04 GMT

in a single object?

Re: Template In qlikview

Anil_Babu_Samineni — Tue, 19 Dec 2017 12:52:49 GMT

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