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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to count number of transactions with different entry dates

Hello everyone

 

I've this table with the columns details as

 

mahnoor1279_0-1685960822222.png

Now i want to show the transactions group by the users in a table ,

but the total of both tables is changed , and when i delete the column of 'DATE'  then this will work fine 

mahnoor1279_1-1685960910243.png

using the below expression 

Count({<ENTER_DATE_RED,CNIC, TRANS_TYPE={'REDEMPTION'}>}DISTINCT TRANSACTION_SNO)

 

 

 

Labels (3)
1 Reply
snibrahim1993
Partner - Contributor III
Partner - Contributor III

Hi @mahnoor1279  I think it counts including the same Transaction numbers 

snibrahim1993_0-1686020205739.png

 

Regards, Mohamed Ibrahim.
If this resolves your Query please like and accept this as an answer.