selection across different dates

yelin_nyu — Sat, 01 Mar 2014 03:53:24 GMT

I want to create a 'master date' dimension, so people pick one date and have all three tables zoomed on that one date.

I thought about concatenate the 3 qty table, but then realize it's bad for my overall data structure which i didn't show in the example below. After few rounds of trying, i realize creating 3 stand alone tbls for each qty is easiest and cleanest approach. I didn't have any syn keys in my actual application, i used product + site# as key, where description of product and site are stored in status table.

So now all i need is the ability for people for find the date they are looking for and update the selection across 3 tables.

topic selection across different dates in QlikView

selection across different dates

Re: selection across different dates