Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create Dynamic Table Box

I have source like this

ID
DateAmount
11-Jan-1810000
12-Jan-1820000
13-Jan-1830000
14-Jan-1840000
15-Jan-1850000
25-Jan-1870000

The goal is like this

ID1-Jan-182-Jan-183-jan-184-Jan-185-Jan-18
11000020000300004000050000
270000

i use generic load but the data separated for each date. the problem is how to union them to one table and create dynamic table box or straight table without manually add new date field to table box properties on presentation layer, because user will add new data daily and didn't know how use qlikview, they know only reload and export excel.

Please Answer this without qvw file, because i use Personal Edition. Thanks

10 Replies
swuehl
MVP
MVP

To hide the Date dimension label, you can grab the right border of the label with the mouse and make the size of the Date label minimal. Then set the label of the Date dimension on dimension tab to

=''

(empty string, two single quotes)