Hi,

I'm trying to create Nprinting filters in Qliksense script, but each time I received error 400

"One of the following errors has occurred:The body of the request is malformed.The app with the specified 'appId' does not exist.One or more connections does not belong to the app with the specified appId.The cache for one or more connection IDs is not in status "Generated".The connection does not contain a field with the specified name."

Based on the documentation I added to the filter's body appid, enabled and name, but issue still appers

Could someone provide syntax of filter body?

Thansk,

Vitalii 

Hello everybody,
I can't write the following formula correctly:

Interval ({<(sum (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')))) = {"> = $ (Start of Month ) <= $ (vDataRifA) "}>}) * Nominale_a /
Sum ({<[Practice Date and] = {"> = $ (Start of Month) <= $ (vDataRifA)"}>} Nominale_a)

Error in expression ')' expected.

You can help me?
Thanks

Hi all,

usually a current selections box shows all the field selections.

But I need to hide one of the field selections and show the other selections into the current selections box.

It exists any method to do this kind of operation?

Regards,

Fabio

Hi All,

I have the following expression, I basically want a table where the Pallet Expected Qty is less than the Stock Cases, so it's not a full pallet of stock

NUM(SUM({<[Product Pick Type] = {'PALLET'},[Product Cases Per Pallet] = {"=[Product Cases Per Pallet]) > SUM([Stock Cases])"}>}[Stock Cases]),$(format.number))

Can anyone suggest why the above expression is not returning the correct result, I would have thought the above would have worked

Thanks.

Hi, thanks for reading this post,

I'm using Dynamic Update on access point and I need to keep added values.

On desktop everything work i have a .bat which run another .qvw witch binary load on the first .qvw and store the Dynamic Update value.

But on access point the Dynamic Update values don't seems to be in the .qww.

Anithing know how can i keep those added value ?

(hope my english is readable, I didn't pratice since years)

I read many other posts, but I can't apply it to my case...

I think "firstsortedvalue" might be the solution.

Here's my Data (I gave my best to get a good example):

What do I want to do:

There are multiple same values for "Calc. Direct Savings CHF", but I only want to see the "Vendor Category", based/ranked on the <highest> "Invoice Amount CHF" per "Direct Savings Year"

Example:

#1, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2019 is higher than #2

#3, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2018 is higher than #4

Finally, out of the 4 lines, only 2 shall remain --> #1 & #3

hope this makes sense!

Thanks already 🙂

Hey guys!

Here is my problem: i have multiple dashboards, that describe different building sites i have. These dashboards look identical, they display identical data, the only difference is building site they bound to. They get data via REST data connection. Currently i create and update these dashboards manually, so i have to edit charts on every dashboard i have. This is acceptable when you have 2-3 dashboards, but with 10-20 and more it becomes painful, so i'm looking for something that will help me to deploy multiple identical dashboards automatically.

My best guess at the moment is using mashups - i will create some sort of mashup template, then programmatically deploy it to my server, as far as i understand it will require programmatic creation of corresponing app and data connection for this app for using in mashup.

Maybe there are more elegant solutions?

Thanks in advance.