Discussion board where members can get started with Qlik Sense.
I have a question. I have this table:
[@1] AS [TotC8.Scenario],
[@2] AS [TotC8.Year],
[@3] AS [TotC8.Period],
[@5] AS [TotC8.Brand],
[@7] AS [TotC8.Account],
[@10] AS [TotC8.Market],
[@16] AS [TotC8.BusinessOrg],
[@18] AS [TotC8.HFMCode],
[@19] AS [TotC8.Amount]
(txt, codepage is 28592, no labels, delimiter is ';', msq, header is 1 lines);
and I want have in output a table where I have all the columns without [@7] and [@19], because I want that the column [@7] is the filed and [@19] is the value of the filed.
How I can do it by using crosstable??
I am not sure if it works without seeing your data and data model. But you can try this.
load distinct [TotC8.Account] as AccList Resident Temp_TotC8;
FOR Each a in FieldValueList('AccList')
TotC8.Amount as '$(a)'
Drop Tables Temp_TotC8,temp_AccList;
View solution in original post
Please try with
with this code I see this:
It's wrong, i want see "STA1000", "STA1130" in fields and the value 0 in rows (it's the amount of the Account --> STA10000,STA1130).
would you mind sharing a sample of your data?
Thanks it is correct. But now I have another problem:
I have the values of the Online Org Orgs, but each PIPPO is associated with one or more ACCOUNTS. I would like to report the accounts in the column and associate the reference BusinessOrg to each one.
and I want 2 columns like : STA1000_TotC8 and STA1000_BOPE.