Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanu_today
Creator
Creator

Date Bifurcation


Hi Everyone ,

I have the samll req like below and do the calculation in design itself for further process.

The dimensions I have is

Account no,custid,aod,period,balance and the logic for the count is count (distinct accountno)

When am writing the below script in our straight table its showing the correct result when am checking the expression total (But idlely that’s not fill my req and attached the sample data here) but when am checking the sum showing different count.

Thanks in adv,

Dhanu

5 Replies
MK_QSL
MVP
MVP

Don't understand what is your actual problem and requirement.

Can you explain specifically?

dhanu_today
Creator
Creator
Author

Thanks Manish,  I have to show the recent balance of account no and later thier count.
Anonymous
Not applicable

Please use cross table to get required output in script

MK_QSL
MVP
MVP

Like this ?

dhanu_today
Creator
Creator
Author

Not working Manish...I have to show like below.

Account NoCustidAODperiodBalanceLogic(count of distinct Account No)
2856924651099902/25/1302/28/13900000(Recent Balance)1
285692410464904/26/1304/30/1347474(Recent Balance)1

Thanks,

Dhanu