topic Re: Monthly Expression in Straight Table in QlikView

Monthly Expression in Straight Table

sona_sa — Tue, 29 Jun 2021 12:20:50 GMT

Hi Team,

Please find the attached QVW and excel.

Any Luck to make an expression for the same.

Thanks

basav — Wed, 30 Jun 2021 07:43:41 GMT

Please explain more about your requirements. Thanks.

dineshm030 — Wed, 30 Jun 2021 11:01:31 GMT

Please Find the QVW.

sona_sa — Wed, 30 Jun 2021 12:55:47 GMT

Hi Dinesh,

Output is correct, Can u build the same in my QVW. Backyear month will follow the same.

Please find the attached QVW.

Thanks

sona_sa — Wed, 30 Jun 2021 13:37:11 GMT

Hi Basavraju, Below is required information :

I have to make an expression for Count in my Straight Table.

For April - (4729 + May Month DOL -May Month DOJ) = 4758

For May - (4718 + June Month DOL -June Month DOJ) = 4729

For June – 4718 = Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)

Please find the attached QVW for ref.

Thanks.

NitinK7 — Wed, 30 Jun 2021 15:32:31 GMT

find the attached QVW, may be it will work to you.

sona_sa — Wed, 30 Jun 2021 16:59:51 GMT

Hi Nitin,

You got my point, But You have to Pick June Month HC = 4718 and It will go back ward.

Please find correct output. It will help you to make an expression.

Regards,

Sona_Sa