I need a cumulative count of the following data:

at the moment I've created a field called 'Count' populated with '1' in the data load and attempted a range sum

Rangesum(Before(Sum(Count),0,ColumnNo()))

which produces the following

I want it to show like this : 

Is there a way to do this - either with the formula I have or an alternative approach?

Hi,

Can you kindly help me understand how to apply distinct count for the following expressions,

count(distinct{<[Price check]={"=If((sum([Dealer Sell-in price])-[Unit Price (EUR)])>0,'N','Y')"}>}[Part Number])

In the above expression,  , Unit Price = sum(Price * Exchange
)/sum(Quantity), Price check=If((sum([Dealer Sell-in price])-([Unit Price (EUR)]))>0,'N','Y'))

Currently, the formula is making distinct count on all the part number but I need it distinct count only the [Part Number] with [Price check] is 'Y' for each Dealer.

Let me know if you need any other details from me.

Thanks in advance

Hi experts,

I am new to Qlik and I need your help. I have two dates fields as shown below. I need to create intervals of 6months below, 2-5 years, etc, and sum my sales based on these intervals. Can anyone help me please? Thank you. 

I upgraded a 'API Key - Raw API Request' block today that was posting raw form data. After the upgrade, Qlik does not send the request to the remote server and returns a HTTP 500 error.

When upgrading, Qlik prompted me that the Form encoded body field was removed. I was already sending a raw body like 'field1=value1&field2=value2' with the 'Content-Type' header set as 'application/x-www-form-urlencoded'. In the previous version of the 'API Key - Raw API Request' it was working fine.

I have tested this with a remote server and with the old and the upgraded block, the request of the upgraded block not arrive at the remote server. The error also indicates something fails on Qlik's side. I would like to know how I can POST form data using the new 'API Key - Raw API Request' block.

Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the button has been selected instead of looking in the filters. Does this exists?

For instance, I have the white button here that is not selected but when it does, it has to become grey.

 

 

Thanks to all of you for your help!

Hi team,

using QEM's Python API is it possible to create new task using a previous task's export file. I want to create 10 tasks using a previous task's export file. I want to know if there is any function called create_task() or someway using which I can create task using python.

Hi,

I installed a new Windows Update and now Qlik Sense Enterprise on Windows is throwing the next error when starting the QMC:

TypeError: Cannot read properties of undefined (reading 'QmcTaskTableCacheDisabled')

Qlik Sense Hub will display nothing, only the waiting growing circles.

The Windows update is this one:

Security Update for Microsoft Windows KB5032190.

Anyone had this problem? Any tips how to solve this?

I have November 2023 patch 2

regards, Emma

G'day,

It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashboard creation for the upcoming Qlik Connect conference in Orlando so I can get certified. Thank you!

Hello everyone,

I have a table with start and end time, and accordingly also with the duration. This is documented for each machine. I would like to display it per machine as a kind of timeline showing how the status has changed in each case. Which diagram can I use to do this? And how do I have to set it up? I would appreciate any help or examples, thank you!