topic Re: Variable doesn't work with inline tablo in App Development

Variable doesn't work with inline tablo

melistrkglu — Tue, 07 Jul 2020 13:08:39 GMT

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

Re: Variable doesn't work with inline tablo

Taoufiq_Zarra — Tue, 07 Jul 2020 10:02:43 GMT

have you tested :

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

for Last3

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

Re: Variable doesn't work with inline tablo

Gabriel — Tue, 07 Jul 2020 10:26:19 GMT

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

Re: Variable doesn't work with inline tablo

melistrkglu — Tue, 07 Jul 2020 13:09:48 GMT

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

Re: Variable doesn't work with inline tablo

melistrkglu — Tue, 07 Jul 2020 13:16:14 GMT

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

Re: Variable doesn't work with inline tablo

Taoufiq_Zarra — Tue, 07 Jul 2020 13:26:21 GMT

Maye be attached ?

Re: Variable doesn't work with inline tablo

melistrkglu — Tue, 07 Jul 2020 19:05:42 GMT

Thanks but it should just be appeared after February 2020.

Re: Variable doesn't work with inline tablo

Taoufiq_Zarra — Tue, 07 Jul 2020 19:53:56 GMT

@melistrkglu

Can you elaborate on the output you're expecting?

Re: Variable doesn't work with inline tablo

melistrkglu — Wed, 08 Jul 2020 06:22:22 GMT

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.