Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New to Qlik sense.. Trying to setup a demo for manager by using some of my data.
Done a few apps before so kind of scratching my head if this is newbie error (hoping so because that means easy to fix) or something deeper.
Task:
Two spreadsheets
Foo.xls
| Product No. | Order Qty | Calendar Year |
| 8284-22A-0000 | 1 | 2017 |
| 8284-22A-5771 | 1 | 2017 |
The last five digets are junk so I have to strip them... no problem
Select table -> edit: Select "Product No." column "split" -> Set to split it after second hyphen
Name new table and see nice new data
oooh.. ah..
Now I have master spreadsheet I made of for key / legends.
Three tabs.. listing the grouping of different brands by "Machine-Model"
Imported tables and they look peachy.. link using "machine-model" as link
Now try to make a simple pie chart with dimension "machine-model"
Drop in pie chart.. click on dimension.. this will need to be a construct of single dimension of "Machine-Model" from split field, but alternative selections of the other three categories.
But as you see... I get weird data. I don't see new "split field" at all called "Machine-Model" but I also don't see fields from the other spreadsheets..
Hoping someone knows quick way to get things working "normal" never had this issue where fields I see in the data manager do not show when going to make charts.