Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Basic % expression help

New to QlikView and don't know how to create a percentage expression for string field with 2 values in a chart.

1 Solution

Accepted Solutions
Not applicable
Author

Hello Racine,

Please find attached qvw.

Please let me know if it was helpful or anything else is required.

Thanks,

Angad

View solution in original post

11 Replies
manideep78
Partner - Specialist
Partner - Specialist

right click--> properties--> go to number tab(select a field for which you want to show in %)--> check show in percent option.

Not applicable
Author

Hello Racine,

You can add a new expression with Field1/Field2 and then on Number Tab, select that expression and select Number radio button and then Show in Percent checkbox.

Thanks,

itsangad

Not applicable
Author

Thanks but my problem is even more basic than that.  I don't know how to create a percentage expression e.g.

"Male" and "Female" values in field "Gender". 

Not applicable
Author

It's a percentage in the same string field e.g. "Male" and "Female" in field "Gender".

Not applicable
Author

Hello Racine,

Please find attached qvw.

Please let me know if it was helpful, or anything else is required.

Thanks,

Angad

Not applicable
Author

Hello Racine,

If you cannot open the qlikview, then please find below explanation :

Write this in Script and then Reload

LOAD * INLINE [

    Gender

    MALE

    MALE

    FEMALE

    FEMALE

    FEMALE

];

Then right click on the sheet and create a chart(Straight Table) with following settings :

Dimension : Gender

Expression1 : =count(Gender)

Expression2 : =count(Gender)/count(TOTAL Gender), for the on the Number tab, select the Integer radio button and select Show in Percent checkbox.

Please let me know if this was helpful or anything else is required.

Thanks,

Angad

Not applicable
Author

Thank you very much for this and it does make sense.  I've still got the problem that I want the % by another variable in a QlikView chart e.g.  gender by year of entry, so that each year has the 100% broken down.  

http://

Not applicable
Author

Hello Racine,

Can you please attach sample qvw with expected results. It might make things easier for me to understand.

Thanks,

itsangad

Not applicable
Author

I want a chart like this in QlikView:-

chart.png