Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Slow Calculations

Good Morning everyone,

I am having an issue with the amount of time it's taking to do a calculation.  When I select a singles sales office response is fine, however when I select a company code the CPU pegs.....Here is my count statement.

Thanks

count(distinct(if(FISPD = FISPD_CNT and InActive = '1' and FISYR = FISYR_CNT,[Employee Number])))

60 Replies
annafuksa1
Creator III
Creator III

Please check my app.

there is no data for 2013 it is why is 0

tmumaw
Specialist II
Specialist II
Author

What did you do?

Anonymous
Not applicable

As a side note, when you are concatenating numbers like that for a key, you probably want to use a delimiter type character to separate the fields within the key.  I usually use a pipe.  For example.

=Field1 & '|' & Field2 & '|' & Field3

This should eliminate the chance of incorrect key duplication.

Anonymous
Not applicable

She added a straight table with a sum by year.  No 2013 when TIMEIND= Y.

tmumaw
Specialist II
Specialist II
Author

You have to keep the TIMEIND at Q because I what Quarterly measures.  There are separate measures based on Y,Q,M,W TIMEIND.....

annafuksa1
Creator III
Creator III

I rewrite the expression that couse problems, I did not change the your table to diffeent format  , I add extra chart to see if my calculation is correct

annafuksa1
Creator III
Creator III

I will say to use auto number function

Anonymous
Not applicable

I would think you would still need a character or autonumber could generate duplicate autonumber value?

So you would need something like this:

=autonumber(Field1 & '|' & Field2 & '|' & Field3)

annafuksa1
Creator III
Creator III

no it cannot be duplicate but this ID will work in one app

its enough

=autonumber(Field1  & Field2 & Field3)

Anonymous
Not applicable

Your expression for 2013 is showing Y as your parameter.