This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Using the same synthetic fields as dimensions, I have this. It is like "1:Many".
But what I want is this (more like 1:1) :
I can achieve #2 if I move one of synthetic fields to become expression but I need both to be in dimension.
Another restriction, values inside the valuelist function will become dynamic later on depending on various selection. This means I cannot do this in load script.
Anyway to achieve this?
Current requirements: The output required is a pivot table with :
Dim1:Top N Countries based on Sales on selected Month.
Dim2: Year 1 and Year 2 (based on user selection)
DIm 3: Periods in the form of 4 Quarters Ago, 3 Quarters Ago, 2 Quarters Ago, 1 Quarter Ago, YTD, MTD, Previous Month, 2months ago appearing at the same time where Year depends on Dim2
Dim 4: Bucketing of Sales: e.g. All Range, 0-$300, 300-600, 0-600. Range can be dynamic based on user input.
Dim 5: Materials in this format:
Where Material 1 is the latest Material for that country
Material 2 is the top selling Material for that country except Material 1
Material 3 is the top selling Material for that country except Material 1 and Material 2
Material 4 is the TOTAL of all Materials flagged as "Special"
Material 5 is the top Material flagged as "Special" but not Material 1, Material 3 and Material 4
Material 6 is the 2 top Material flagged as "Special" but not Material 1, Material 3 and Material 4 and Material 5
Material 7 is the top 1 Material NOT flagged as "Special" but not Material 1, Material 3 and Material 4
Everything is working with valuelist() then comes Dim6 as the new requirement
Dim6: Categorized Dim3 if "Quarterly", "Yearly" or "Monthly"
I'm looking for one that will not touch the expression anymore. Or any alternative solution that I can play with.
Can you post some sample data in Excel?
can you post sample app/ sample data?
Preparing examples for Upload - Reduction and Data Scrambling
Data is nothing fancy. Very straight forward.