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?

Quando visualizo um grafico em tela cheia a tela não está responsiva e abre a barra de rolagem na vertical.  Qual a solução? 

Esta situação não acontecia há uma semana atras, será que é um problema do produto?

Hi ,

Could someone help me rectify the error in following script(Attached screenshot).

Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.

I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.

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

I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.

Below is how I would have it created in Excel:

This makes an easy year on year comparison possible.

But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?

I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).

Hi,

I want to change the color of the header of a column. For instance, in the printscreen below, I want for "Original budget 2024" to be yellow. Is their anyway possible?

Thank you!

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. 

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 

I'm facing problems to connect the excel complement to the spreadsheets.

I used to do the login but the account was not with the plan to use this complement, so our account manager gave us a tria. Since then I can not reach the login

Attached you wil find images that the excel complement it is not turn on in the managment console and the response of our account manager (Alexis Whittaker - Alexis.Whittaker@qlik.com)