Hi All,

I need help with section acesss.

In the below table has the sample data where i want to apply Section access User level, but with some condtions.

Dep, ID, user
123 1 AAA
123, 2, BBB
123, 3, CCC
456, 4, DDD
456, 5, EEE
456, 6, FFF

User BBB and CCC reports to AAA - So AAA should see data for himself and also for BBB and CCC only.
Where BBB and CCC should see only their data

Same way, User EEE and FFF reports to DDD- So DDD should see data for himself and also for EEE and FFF only.
Where EEE and FFF should see only their data.

Please help me.

Thanks in Advance

Hello,

I have a simple timeseries data representing a sales event log. I would like to create a new column in script editor that classifies the given Ops id as WON, LOST or PENDING based on the below conditions:

IF for a given Ops id a "Deal signed" milestone exists, the new column (status) should return WON for all of the Ops id records

IF for a given Ops id a "Opportunity cancelled" milestone exists, the new column should return LOST for all of the Ops id records

IF none of the above, then new column sould return PENDING

Excel example attached, will appreciate any advice

Hi,

I am new to Qlik sense and need a little bit of help. 

I need to insert a static target based off of the average number of customers  from a financial year over 52 weeks. I believe I need to count the total amount of customers id's first, then sum them, then divide it by 52 weeks to get the average.

So in excel terms it would be IF( Financial_Year ='2020/2021', Sum(count(Customer_ID)/52)," ")

I then would need to create and upper and lower target with a 5% variance each way 

If have the first part created using set analysis: Count({ $<Financial_Year ={'2020/2021'}>}count(Customer_ID)

I have a calendar variable that breaks down our financial weeks that I am using to plot on the graph. 

Open to all suggestions, and really appreciate the help.

Below is a graph of how I envisage it to look.

I am open to any suggestions and appreciate the help  :).

Thanks,

Alex

Hello all,

I have as an example:

I want to do some calculations based on the value selected in Field_a (as an example GetFieldSelections(Field_a)=y)

let vTest_y=B0_y + B1_y + B2_y;

B0_y, B1_y, B2_y are already loaded as fields.

I want only to catch them based on the selected value and to affect the calculated value into new variable named vTest_y.

Any help please?

Thanks in advance.

Bom dia !

Não consigo baixar o arquivo .exe do QlikSense Desktop. Já tenho conta no Qlik e quando digito entrar ele dá Mensagem:

Obrigado pelo seu interesse no Qlik Sense... envia um email mas para avalição do Sense on Cloud Services

Alguém sabe como baixar o .exe ???

Grato

Hi experts,

I have a table that shows segments of the customers with validity start date and validity end dates like,

What i am trying to do is to count the customers according to their segments for a specific as-of date.

For instance if as-of date is 17-03-2021 (=vAsOf) counts should be:

newcomer:0

loyal:2

premium:0

What i did is in a KPI object for , say, "Loyal":

measure:

count({$<segment = {'loyal'},vAsOf={">=$(=firstsortedvalue( validityenddate= {'>$(=vAsOf)'},validitystartdate= {'<$(=vAsOf)'} >} validitystartdate,-validitystartdate))"}>}distinct [customerid])

But it is not right. 

Could you please help me on the problem?

Regards,