Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dhanu_today
New Contributor III

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

Re: Date Bifurcation

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

Can you explain specifically?

dhanu_today
New Contributor III

Re: Date Bifurcation

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

Re: Date Bifurcation

Please use cross table to get required output in script

Re: Date Bifurcation

Like this ?

dhanu_today
New Contributor III

Re: Date Bifurcation

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

Community Browser