Discussion Board for collaboration related to QlikView App Development.
I have the underlying data
|Type 1 | Type 2 | Type 4||Feb|
|Type 3 | Type 4||Mar|
|Type 1 | Type 3 | Type 4||Jan|
and I need Qlikview to show this:
I thought Mapping would work, but there seems to be a conflict when the same type rolls up into the same name.
Load *, Trim(subfield(Type, '|')) as NewType;
LOAD * INLINE [
Type 1, Jan
Type 1 | Type 2 | Type 4, Feb
Type 3 | Type 4, Mar
Type 1 | Type 3 | Type 4, Jan
Type 1, Feb
DROP Table CountText;
Take Pivot table Dimensions = NewType and Month
Expression = count(NewType)
However this seems restricted - the document I am working on have over 3000 entries and that can change over time. Is there a way to create the above that can take this into account?
Apologies, my knowledge on Qlikview isn't the best. Are you able to elaborate on this.
Also, the data above is only a sample - the document I am actually working on has far more entries that can change over time.
You have to implement script as qv_testing suggested. Just try what he suggested if it is not working then let us know.
That was just an example using the data you provided in your OP embedded in an INLINE LOAD.
Replace the INLINE [...] part with a FROM YourSource clause and the data processing will follow whatever is present in your source data at a particular point in time.
I wish I could. Unfortunately it is work related and therefore strictly prohibited.
Is it possible to have the formula recreated without the Inline piece? Lets say my underlying data is called Database.xls for example.
Perhaps that is where I am going wrong