Hi,

we use cakemail to send out email campaigns, and the result of these campaigns can be retrieved using cakemail's legacy API services.

The rep gave me an active API key and a link to their developper knowledge base : https://developer.cakemail.com/legacy/

All the getting started examples are for PHP and Curl. 

All the examples I see for Qlikview in the forums and community require some xml file which I can't find in the cakemail documentation. In short, I'm out of my league at this point, and wondering if anyone would have a good pointer to getting started for retrieving data using an API key. Or at least a basic Qlikview tutorial to suggest.

Thanks

Hi All,

I have a application which is having dependency on multiple tables. Every week we need to load the data into application, but data will be delayed some times for few tables.  User requested us to load the data which is available and remaining can be done once the data is received.

Is there any way to load the data to application, only those remaining tables when ever delay is happened??

Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. 

How can i associate my forecast data to a date if not like this?

Hello everyone all,



I have the following table:




It is a pivot table.

In the sub-total section, I would like to add the percentages instead of adding the percentages, while keeping the direction column.

Because I know that I can achieve the average by removing this column but I would prefer to find another solution.

Thank you in advance.

Hello Friends,

Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a selection in my Qlik Sense table.

for example,

let say I have the below table

customer,units

1,10

2,20

3,30

4,40

5,50

In a QS table, when I click  the first row, the rest are all getting removed, Is there any way to show it in a gray color instead?

I have attached a demo app for your reference

below is my expression

units: aggr(sum(qty),customer) 

Thank you,

Kiruthiga

Hi!

I have  some data in a Sense as below.

What I want to do is when the 'Ordering Code' is empty and 'Telsims_Product_Group' contains 'LAN' or 'Telefoni', I want to add 'Broadband' for 'LAN' and 'Voice' for 'Telefoni 'in a new column (Order_new).

I have tried with and expression looking like this but it doesn't work as i want :

=if ((isnull([Ordering Code])and isnull(Product)) and (Telsims_Product_Group='LAN'),('Broadband') or
(Telsims_Product_Group='Telefoni'),('Voice'))

Any suggestion?

Hello everyone

I'm trying to put a password in an app in qlik sense (because I know that it is possible to do that in Qlik view) but is not working. Anyone know if it is possible and can help me with an example?

So much thanks to all.

Hi

I´m trying to connect to SAP using the SAP SQL connector. The connector is avaliable but I receive a mesage that I can´t use it....

Any ideas or comments? Is this a bug?