Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
Creator III

TOTAL doesn't work on caclutated if dimension

I have data about the usage of transportation by day.

I wanted to make a slider where you could select a day and see which clients already used that kind of transportation.

With a TOTAL I could make percentages by transportation.

There is also a calculated dimension that divides the clients in 2 categories: 'used it' or 'didn't use it'.

No problem so far.

But when I wanted the make the calculated dimension I bit more relevant it doesn't work anymore. I used an if to make more categories like: 'bought a ticket', 'no ticket', 'used', 'not used' ...

Anyone a suggestion how to solve this?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like attached

View solution in original post

4 Replies
avinashelite

Total work's on the columns which you have created in the script, try to push that calculated dimension to the script and use the same with the TOTAL key word that should work

kristof_j
Creator III
Creator III
Author

Yes I know but I don't find a way to push it in the script.

I let the user choose the preferred period and the dimension has to chance accordingly. It is not something you do so easily in the script.

swuehl
MVP
MVP

Maybe like attached

kristof_j
Creator III
Creator III
Author

lovely