Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kristof_j
Contributor II

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
MVP
MVP

Re: TOTAL doesn't work on caclutated if dimension

Maybe like attached

4 Replies

Re: TOTAL doesn't work on caclutated if dimension

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
Contributor II

Re: TOTAL doesn't work on caclutated if dimension

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.

MVP
MVP

Re: TOTAL doesn't work on caclutated if dimension

Maybe like attached

kristof_j
Contributor II

Re: TOTAL doesn't work on caclutated if dimension

lovely

Community Browser