Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have source like this
ID | Date | Amount |
---|---|---|
1 | 1-Jan-18 | 10000 |
1 | 2-Jan-18 | 20000 |
1 | 3-Jan-18 | 30000 |
1 | 4-Jan-18 | 40000 |
1 | 5-Jan-18 | 50000 |
2 | 5-Jan-18 | 70000 |
The goal is like this
ID | 1-Jan-18 | 2-Jan-18 | 3-jan-18 | 4-Jan-18 | 5-Jan-18 |
---|---|---|---|---|---|
1 | 10000 | 20000 | 30000 | 40000 | 50000 |
2 | 70000 |
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
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)