Template In qlikview

[Anonymous]

Hello Everyone.

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

[Chanty4u]

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,',')

[stabben23]

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

[Anonymous]

i don't want to used concat.

[Anil_Babu_Samineni]

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

[Anonymous]

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

[Chanty4u]

try this

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

[Anonymous]

something is wrong there

[Chanty4u]

check now

a:

load  * Inline [

Categ ,Year

Car,2014

van,2014

Car,2010

van,2017

Car,2000

];

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

[Anonymous]

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.