Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pabloperezgarcia
Contributor II
Contributor II

Calculate percentage based on distinct values from same column (pivot table)

Hello,

I need to know how to calculate percentage based on distinct values from same column (pivot table) only adding one column. 

Something like this:  

pabloperezgarcia_0-1627407889285.png

Regards,
Pablo Perez 

 

Labels (3)
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

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?

Cheers,

Chris.

View solution in original post

4 Replies
chrismarlow
Specialist II
Specialist II

Hi,

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?

Cheers,

Chris.

View solution in original post

pabloperezgarcia
Contributor II
Contributor II
Author

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.

pabloperezgarcia_1-1627410222045.png

cheers,
Pablo

 

chrismarlow
Specialist II
Specialist II

Hi,

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.

Cheers,

Chris. 

pabloperezgarcia
Contributor II
Contributor II
Author

Chris, 

It worked well, thank you!! 

Cheers,

Pablo Perez