Agg in Qlikview

[dunnalahk123]

Hi,

Can some one help me here , i have one project  but for that project  i have two different Template codes .

basically i have created 2 flags based on those template codes like you see in below snapshots T3415 and T3416

so One template code has Qualified for T3415 and other one is Qualified for T3416  because of that i am getting 2 rows

but i need everything in one row for Project . so that i can remove Task Template Code dimension

how to do that. or how can write in expression ?

[dunnalahk123 · Accepted solution]

Hi,

When we create a flags like T3415  gives only value to 1  instaed of writing 1or 0 and then in report expression add just field .

in suppress zero instead of" -" make it as 0

it works .

[dunnalahk123]

Hi,

When we create a flags like T3415  gives only value to 1  instead of writing 1or 0 and then in report expression add just field .

in suppress zero instead of" -" make it as 0

it works .