Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

list of fields names rather than numbers

HI, I am new to Qlikview

I have fields with field name and numbers below

Sales 1
101
102

103

e
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

4 Replies
Gysbert_Wassenaar

LOAD * INLINE [

Sales

Sales 1

Sales 2

Sales 3

]


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

HI

post your proper requirement

Thanks

Anonymous
Not applicable
Author

Hi

Take pivot table add all dimensions into that you will get like above

Sales
Sales 1
Sales 2
Sales 3

Thanks

Not applicable
Author

SALES.png

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

SALES1.png