topic Re: Date Bifurcation in QlikView

Date Bifurcation

dhanu_today — Thu, 06 Mar 2014 15:17:49 GMT

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

Re: Date Bifurcation

MK_QSL — Thu, 06 Mar 2014 15:26:08 GMT

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

Can you explain specifically?

Re: Date Bifurcation

dhanu_today — Thu, 06 Mar 2014 15:34:57 GMT

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

Re: Date Bifurcation

Anonymous — Thu, 06 Mar 2014 15:40:03 GMT

Please use cross table to get required output in script

Re: Date Bifurcation

MK_QSL — Thu, 06 Mar 2014 15:42:02 GMT

Like this ?

Re: Date Bifurcation

dhanu_today — Thu, 06 Mar 2014 17:02:06 GMT

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

Account No	Custid	AOD	period	Balance	Logic(count of distinct Account No)
285692465	10999	02/25/13	02/28/13	900000(Recent Balance)	1
2856924	104649	04/26/13	04/30/13	47474(Recent Balance)	1

Thanks,

Dhanu