Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, I am new to Qlikview
I have fields with field name and numbers below
| Sales 1 |
|---|
| 101 |
| 102 |
103 |
| Sales 2 |
|---|
| 201 |
| 202 |
| 203 |
I need like below
| Sales |
|---|
| Sales 1 |
| Sales 2 |
| Sales 3 |
I have sub categories to Sales 1 ----> Sales 1.1,Sales 1.2
Please let me know how to work above
LOAD * INLINE [
Sales
Sales 1
Sales 2
Sales 3
]
HI
post your proper requirement
Thanks
Hi
Take pivot table add all dimensions into that you will get like above
| Sales |
|---|
| Sales 1 |
| Sales 2 |
| Sales 3 |
Thanks

In the above image I have all fields with Fields names and Numbers below but my requirement must look like:
