Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

No of days using the flag filed???

Hi Folks,

Here i have Period, Factor, Id as dimensions and (A Amount, B Amount, Diff Amount, Diff Flag, No. of Days) ---> expressions.

Diff amount is (A-B) in %, and Diff Flag is if Diff amount is > 3% and <100% the 1 or 0.

upto here it is fine.but i need the no.of days(means how many days are having 1 value in the Difff Flag column.

PFA of source file.

Thanks in advance.

2 Replies
kaveri_bhar123
Contributor II
Contributor II

Hi Nagapuri ,

Load period,

1 as Daycounter

resident … where [Diff flag]=1;

sum(Daycounter0 will give how many days have [Diff flag]=1

Regards,

Kaveri

Not applicable
Author

Hi,

Thanks for your reply.but i want it in the front end(pivot or straight). in need the expression for that No of days using the Diff flag.

like if(Diff flag=1,count(period)) but its not working fine