Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore calculated dimension in pivot table

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:

delete.png

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.

4 Replies
Anil_Babu_Samineni

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

This gives me 100% for all cells.

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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