Welcome to Qlik Community

Hi Everyone,

I am facing issue with one of the KPI. I need to calculate Yearly accumulated of Spend_actual per supplier . Sample data as below  , Here I need to get count of total suppliers who provided 80% of spend (KPI1) and also need to count the % of the supplier who provided 80% of Spend (KPI2) .

#suppliers providing 80% spend = count of (supplier in top 80 % spend  ) 

% suppliers providing 80% spend = count of (supplier in top 80 % spend  )  /Total suppliers

I came up with formula to calculate accumulated spend_actual per supplier :

num((RangeSum(Above(SUM({<$(vSet)>}SPEND_ACTUAL), 0, RowNo())))/(sum({<$(vSet)>}SPEND_ACTUAL)),'###.##%) 

But I am struggling to get top suppliers who provided 80% spend.

Kindly Please help.

Hi, 

I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to created an if statement in my script to identify just the client records  whom has a special character in the (SMSNo) field and where the number does not contain 10 digits. I also want to eliminate the fields that are blank.

Thank you

Hi guys,

Please Help Me to get  Free Horizontal list box or filter pane extension which is working,

Need a Filter pane which shows the values in horizontal without a dropdown option 

Hi Team,

I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So I need a flag like Y for all those value selected and N means not selected records.

Hope you got my answer. Can any one help me on this.

For data related qvw, I am attaching my qvw.

Regards,
Sona_SA

Hi All , 

Please find the attachment of the excel sheet , 

I want to show subtotal and Total  in a table in QlikView . 

I have Department and Category and Sales , 

As shown in the screenshot below is it possible to achive this in Qlikview ? 

Thanks in Advcance 

Hi there,

I observed the following behaviour. Can someone tell me if this is a known limitation, architectural design, known bug or something else entirely?

I simplified the problem for this forum.

Let’s say I have one SSE function: SSE.Increase, which will increase a given field by 5.

Additionally, my datamodel has one table with 5000 rows and two fields:

with my_id being a dimension and my_number a measure.

Now, if I build a table in a QlikSense sheet with:

my SSE function will be called once with 5000 rows => high performance.

2nd try: I now change my table to:

This will lead to my SSE function to be called 5000 times with 1 row each => significant decrease in performance.

And lastly, another table:

This time, again, QlikSense will call my SSE function just once with 5000 rows => high performance. This table will lead to the same results as table #2, but with a much better performance (and some additional columns...)

I tested this with the latest Qlik Sense Version.

As I stated in the beginning: Why?

Thanks.

Murat

Hello Folks, 
Looking for help. Can you give some insight to provide Top 3 customers by sales plus top 3 customers by product count.

Appreciate your time and help.

I am joining two tables.Lets say for example(Table A, Table B)

Table A:

A,B

Table B:

A,C

The result from the above is not matching when I put outer join between these two

Table A:

A,B

outer join(Table A)

Table B:

A,C

Ideally both should be same right?

Hello,

I tried many time to find a solution but its still doesn't work out. I loaded a table with a Revenue_Month field like the following.

Qlik didn't recognized as a Date field, so I put a additional Date function in the loading script like á la Date(date#(MM.YYYY),'DD.MM.YYYY') as Revenue_Month. Now Qlik know its a date I also got automated.date function to chose from. Since I add the days also, I got the following table: 

Now I want a KPI Window which always shows me the Revenue_Target of my current month. I don't want a sum of the values, so for instance when now its May I just want to display  '28170000' and next month in June it should return '30000000'. 

I tried many variation of set expression combined with like this with and without "distinct": 

=Sum({<[Revenue_Month]={'<=$(=Date(Today()))'}>}distinct [Sales])

or

Sum({<[Revenue_Month.automated.Month]={'<=$(=Date(Today()))'}>}distinct [Sales])

also

If-Function like: if (Revenue_Month==$(=Date(Today()), distinct Sales)) 

never worked out for me. Mostly I got some aggregated big amount but mostly 0 respectively no value at all.

Hope someone has an idea whats going on here. 

Thanks in advance!