Hi I'm migrating a pixel perfect report from NP16 to NP18 Jun 2019.

After importing the report, I keep adding the object from the Qlikview source and the preview works properly as soon as I don't use Levels.

As I try to import an object as Level and I bind a field to the report the preview fails giving this error

"An error occurred while elaborating the entity tags.
Please check if the entities are properly placed inside their level tags"

NPDesigner and Server are both 19.19.4.0

Hi everybody,

I have 2 tables like this 

Table1

Relationship

All I want to do is to create a straight table with Model and ReportMonth dimension, and count the number of VIN1/VIN2 for each Model when WSMonth = ReportMonth

expect result :

what should my expression looks like ?

Thanks !

Dave

my calendar is working on this =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)

but its not working on my sell thru code.

sell thru formula is :-=Sum (InvoiceQuantity)/Sum (TransactionQuantity)*100

i did like this to attach my calendar but its not working  and data is not showing ,=Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}(InvoiceQuantity)/(TransactionQuantity)*100)

please help

Hi Folks,

I have got below scenario where i need to display only positive values and values within 100% only.

Example:

This is my sample pivot table-

Now i need to display only the values which are positives and below 100% only.

I am sure , i need to write expression in Value(Measures), under show column if. But not sure how to write for the above scenario.

Note: The logic for Value = (1-(Sum({<[C-Desc]={"N/A","0001","N/A(BLANK)","()"}>} DValue)) / (Sum([Location Rate])))

Value2 = (1-(Sum({<[C-Desc]={"N/A","0001","N/A(BLANK)","()"}>} DValue)) / (Sum([Land Rate])))

*C-Desc and Dvalue are others fields.

Thanks in advance,

LP27

Hi, 

I have a textbox that shows the value accordingly based on the year i hardcoded in.

=count({1<[DTO Year]={"2019"},[YTD DTO]= {">=45"}>}DISTINCT [Customer])

Currently, i'm trying to display it when user select the year but can't get it right. 

When no selection, display the max year, else display the value accordingly. if(GetFieldSelections ([DTO Year]) = '2016',
count({<[YTD DTO]= {">=45"}>}DISTINCT [Customer]),
if(GetFieldSelections ([DTO Year]) = '2017',
count({<[YTD DTO]= {">=45"}>}DISTINCT [Customer])))

Dear all,

starting from the sample data attached, in Qlik Sense i want to create a table with a simple average of quantity per product and in the total the summary of all averages (not the grand average).

So i would like to specify one formula for the details and another one for totals. is it possible?

Below the result i have to achieve.

Hi all,

We have created the reload task on central node server and all generated qvd will be stored in central node server.

How could we reload task by other rim node and those node can access the qvd?

Thanks a lot.

Best Regards,

Louis

Hi All,

Is there information about the latest Qlik Sense product security audits? For example tests complient with "OWASP  Application Security Verification Standard 3.0.1".

Does anyone have some test results? If yes, can You share it privately?

Best regards