topic Ignore calculated dimension in pivot table in QlikView

Ignore calculated dimension in pivot table

Fri, 12 May 2017 06:24:03 GMT

I have a table below:

Column dimension: if(flag=0, 'local', 'XB')

Row dimension: time_bucket

Expression:

1. count(id)

2. count(id) / count(total <flag> id)

What I want to show:

How ever now it's not working, it's showing percentage as over 500 instead of 100 or 400.

Any thoughts?

By the way, this expression works if the dimension is not a calculated one. Tested. So weird.

Anil_Babu_Samineni — Fri, 12 May 2017 06:28:36 GMT

Due to Total it may behavior. Try to remove that and check

2. count(id) / count({<flag>} id)

Fri, 12 May 2017 06:30:38 GMT

This gives me 100% for all cells.

Anil_Babu_Samineni — Fri, 12 May 2017 06:32:06 GMT

Would it possible to share sample and expected result. That would be more helpful

Fri, 12 May 2017 07:07:14 GMT

It's weird. I tried this expression in both QlikView and Qlik Sense. It works fine in QlikView but not in Sense.