topic Filter 2 tables by different months for M/M comparison in QlikView

Filter 2 tables by different months for M/M comparison

ssc8aug — Fri, 15 Nov 2024 23:12:33 GMT

Hi,

I have a simple problem, I need to create 2 simple tables side by side. One table will show number of customers for the selected month, I need the second table to show the same values for previous month, I am selecting month from a list box, so every time I update it , the table on the right should automatically show 1 month prev values.

The month variable is not present in dimensions/expression so i need full table filetered. Please help.

Re: Filter 2 tables by different months for M/M comparison

edwin — Wed, 03 Feb 2021 15:04:54 GMT

the first table should be a simple
sum(MEASURE)

for the second table the usual solution is to use a variable to either store the selected date or previous month of selected date
vPrevious=addmonths(DATE,-1) assuming only one date is selected
then in your expression
sum({<DATE={'$(vPrevious)'}>}MEASURE

having said that, wouldnt this be better shown as a single chart where the current month and prior months are shown side by side? bec if the user sorts one table, the second will not follow