I am still new to Qlik Sense and learning my way in to it. I am using a Pivot table and want to show today and yesterday's data only in my Pivot table. I have 2 dimesnions , 1 column and 2 measures.
I have years of data coming from SQL but my requirement is to just show 1 day data only (yesterday). For this I am trying to use an expression in my measure which is something like below but it still shows whole data.
In the above expression I am trying to filter out on my date field where date = today() -1 to get yesterday data, but seems like not working.
Can you please help me to filter the complete data set with just 1 day value on any date field.