We now have 3 bars of data: the first is ID 1,name aaa,gender:boy, the second is ID 2,name bbb,gender:boy, and the third is Id 3,name ccc,gender: gril, now I want to use the filter provided by qlik sense to filter all the data whose name is aaa or gender is girl. How can I achieve this? Normally you should get data with ID 1 and ID 3

Qlik Cloud

Hello guys,

I am facing since the 6th december 2022 a problem with applications using Store instruction on a Google Drive folder.

Everything worked fine until this date. Applications runned hourly without any problems and all my QVDs were generated correcly.

Since the 6th december at 08:00 PM CEST, my reload tend to fail on a random Store instruction. By random, I mean that it is not especially one QVD.

I have 2 types of error thatI am facing

Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Cannot open file: 'lib://Google drive connector/<idfolder>/accounts.qvd' (Connector error: Error completing job: Object reference not set to an instance of an object.)
The error occurred here:
Store accounts into [lib://Google drive connector/<idfolder>/accounts.qvd] (qvd)

Data has not been loaded. Please correct the error and try loading again.
The following error occurred:
Cannot open file: 'lib://Google drive connector/<idfolder>/projet .qvd' (Connector error: Exception in reading response chunk for upload: Status(StatusCode="Unknown", Detail="Error during upload: Object reference not set to an instance of an object."))
The error occurred here:
Store projet into [Google drive connector/<idfolder>/projet .qvd] (qvd)

 Do you guys have an idea about why do I have this errors? Are you facing the same problem since the 6th december too?

hello All,

Hello All,

Does anyone facing the dataloading issues with license monitor app in qlik sense? 

License app error:

Team,

In below table i want to display 0 instead -, how to do, i tried with multiple options including Alt but still no luck.

Current expression : if(count({<name= $::name,[Doctor State]=$::[Doctor State]>}[Doctor State])> 0,1,0)

Any suggestions to sort this issue. Thanks in advance

Greetings,

A simple mashup with the most basic template with about 10 records that has 2 graphs and 2 kpis on initial load takes about 10 seconds.

It is running on a central node server with a real two core processor with 4 virtual cores at 2.39 ghz and 32 gb of ram.

Can it be due to the low specs of the server ?

Because if not I don't understand why it is hard to load such a simple mashup.

The server does not have any other service installed and looking at the task manager does not seem to suffer the server on the contrary it goes quite well.

Is there any kind of configuration to make it work better ?

Thanks.

Hi,

I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current expressions are:

Sales: Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)

Sales Previous Month: Above (Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)) 

Need help with the expression for "Sales Prev Year".  

Appreciate any help!

Regards,

Bhaskar

I'm using Field API to filter some tables. However if the value I'm filtering doesn't exist it returns all of the results in the table. I want it to show a message like "no results" or whatever it doesn't matter. How can I achieve this?

app1.field("testFilterID").selectValues(["test"], false);

Hi 

I am trying (in vain) to get a dynamic file name loaded.

The file is located at 

C:\Temp\SEPA\Pending Upload

I have a variable vFolder C:\Temp\SEPA

Mu script which worked until we moved servers...

The load appears to do nothing.so obviously I have something wrong. Any thoughts or suggestions would be appreciated.

Thanks

Rob