Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
prachi91
Creator III
Creator III

Template In qlikview

Hello Everyone.

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

14 Replies
Chanty4u
MVP
MVP

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

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

prachi91
Creator III
Creator III
Author

i don't want to used concat.

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prachi91
Creator III
Creator III
Author

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

try this

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

prachi91
Creator III
Creator III
Author

something is wrong there

Chanty4u
MVP
MVP

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

caten.PNG

prachi91
Creator III
Creator III
Author

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.