I'm new to Qlikview and am in the process of building my first application.
So far, I have loaded in data from 3 sources from excel, and concatenated them together using the script editor as they have consistent field names and formats, which enables concatenation. I have a field in that dataset called 'source', with values equal to 'A','B' or 'C', which enables me to identify which source particular rows in the data originate from.
For the sake of this example, I would like to build a straight table which users can use listboxes to drill down to. I would only like data to be displayed in this table where, in the input dataset, source = 'A'. I was wondering if anyone could shed light on how or where I would do this - I presume a conditional expression is required somewhere in the 'Chart Properties' window but I am not sure what that should be or where.
I hope this makes sense, and any advice would be greatly appreciated.