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.
I searched many times in the forum but I could not find the answer. Please advise if I'm using the wrong keywords.
I have two charts:
Sample data of the pivot table:
How can I achieve this on one sheet?
please provide a dataset that best replicates your scenario
Here is link to resources for beginners that may be helpful in getting started
search for more content on Set analysis on Community and Youtube, below are some links
Beginners' Introduction to Set Analysis - Qlik Sense and QlikView - YouTube
Dates in Set Analysis
Thank you! The Set Analysis is very powerful!
Unfortunately, I still could not figure out how to achieve the table above.
Allow me to elaborate, I want the table above to appear if I select in my filter "Jan-16", so automatically the preceding 13 months to appear too.
Here is the solution I found somewhere on the community and thought of sharing just in case someone can benefit from it
The key was to use the Only() function and the range. Correct my description if I'm wrong, please.
You don't need only here
Yes, it worked without Only(). Thank you
Here is the revised solution just in case someone can benefit from it