Variable doesn't work with inline tablo

[melistrkglu]

Hello,

Variable doesn't work with inline tablo.

We created this in script:

LOAD * INLINE [
Button
Include
Exclude ];

We used this expression:

=if(Button='Include', sum({<Date={">$(vLast3)"} >} Sales),
if(Button='Exclude', sum({<Date={">$(vLast3"}>} Sales_SIZ) ))

Last3 variable:
=addmonths(max(Date2),-3)

Button is used as filter but when we use button, expression doesn’t work correctly and it still brings all dates although we work with ">Last3".

It should show after February 2020 according to this case.

I attached qvf, excel and screenshot.

Thanks for your help.
King Regards,
Melis

[Taoufiq_Zarra]

have you tested :

=Date(addmonths(max(Date2),-3),'MM/YYYY')

for Last3 

or can you share a sample data and the expected output ?

[Gabriel]

Hi,

Please upload .qvf file.

Or check the you have uncheck Include null values under your Dim and also uncheck under Add-ons Data handling Include zero values.

Try that and if it doesn't work upload your .qvf file

[melistrkglu]

Thank you but it does not work. I updated my case and added qvf, excel and screenshot.

[melistrkglu]

I had uncheck null values under Dim. However, I can not have uncheck under Add-ons Data handling Include zero values because I should see zero values in dates which are required. I uploaded qvf and excel file.

Thanks for your answer

[Taoufiq_Zarra]

Maye be attached ?

[melistrkglu]

Thanks but it should just be appeared after February 2020.

[Taoufiq_Zarra]

@melistrkglu 

Can you elaborate on the output you're expecting?

[melistrkglu]

I want exactly this as image but zero values should not be hidden. For instance, if there is zero value in 5 May 2020, it is necessary to see it.