Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai experts.
how to split excel sheet cell values in qlikview. For example my data is below model, i will get data as output & count the values in excel sheet.
Header 1 | Header 2 | Header 3 |
---|---|---|
sap | output | count |
1,2,3 | 1 | 3 |
4 | 2 | 1 |
5 | 3 | 1 |
6,7 | 4 | 2 |
5 |
You could use something like this:
load sap, subfield(sap, ',') as output, rangesum(substringcount(sap, ','), 1) as count
from excel;
- Marcus