last year data not showing because account number ... - Qlik Community

Rajkumar · ‎2022-01-18

Hi All,

last year data not showing because account number not in current year.

Ex. If I select Year 2021 , account number 1000121 does not have entry. So, it is not showing as last year data the year over comparison.

Advise to show the account though it is not present in current in last yea vs current Year report.

regards

Raj

canerkan · ‎2022-01-18

Hi Raj,

i'm not sure if this is what you are looking for but try something like this to concatenate the missing accounts to your existing table:

Assuming you have a Table where all your accounts are listed:

Concatenate(Your_Table)

Load
Account,
0 as Value
From ListOfAllAccounts
where not Exists(Account);

You might need to adjust the Fields to your existing table but in that way you can add the missing accounts with a value 0.

If you want more help i will need some sample Data to understand your Datamodel.

Check the link to qlik help to see how to use the Exists() function.

Regards,

Can

last year data not showing because account number not in current year.