I am fairly inexperienced in Qlikview hence seeking some help.
I have a dataset with fields including (Media, Date, GRPs, etc). I want to create a table which shows me all my metrics in rows and date in columns. I want to be able to -
1. Select a date from a calendar object 2. Lets say the selected date is 'D' and month for selected date is 'M' 2. Basis the date selection, I want to auto populate the columns 3. The columns should be as - 'D', 'D-7', 'M', 'M-1' 4. So essentially what I want is daily, weekly or month on month comparison - all in a single table 5. If you could help me get 'Month Till Date' comparison with last month MTD also, it would be fabulous!!