If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need to know how to calculate percentage based on distinct values from same column (pivot table) only adding one column.
Something like this:
Do you know the table is only going to have 2 dates and model as row?
If so how do you identify the dates? Because this would likely be easier to do as a straight table.
If it could have more than 2 dates, how would you display that?
View solution in original post
I'll managed only two dates values to compare. The pivot table is something like this and I need one more column to calculate de percentage.
Other folks may know better tricks but I think this is a bit fiddly with the out of the box visualisations.
You could look at some of the ideas on the attached that might get to what you need.
It worked well, thank you!!