Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabbar
Specialist
Specialist

Same Set Expression giving different result with and without field

Gabbar_0-1672835187235.png

Image 1

 

Gabbar_1-1672835217513.png


Image 2

In image 1 and 2 C1 is same measure, but without field it is giving C1 and adding any field is giving a table like Image 2(total of measure is same in all the cases).
Help Please

 

Labels (5)
14 Replies
Gabbar
Specialist
Specialist
Author

Not giving correct results

 

vinieme12
Champion III
Champion III

post some sample data

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Gabbar
Specialist
Specialist
Author

Gabbar_1-1672994147711.png

 

C1 is my expression C2 is yours
Now for those 2 Eid's

Gabbar_2-1672994317079.png

for the eid ending with 092 , there is expiry between required dates and it is not getting created again
so it needs to counted, 
Similarly for eid ending with 152 the last row satisfies the criteria and no other row disqualify that so it should also be counted but both of these are not counted by your expression.

Also my problem is that my expression isnt working properly without dimension  or when dimension is eid.

 

 

vinieme12
Champion III
Champion III

can you post a larger sample in excel?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

or try the same expression but create a new unique field to identify each record separately

,Eid&CreatedDate as Eid_unique

 

=Count({<Eid_unique=

p({<[Expiry Date]={">=$(=44652)<=$(=44742)"}>-<[Created Date]={">=$(=44742)<=$(=44834)"} >} Eid_unique)

>}distinct Eid)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.