topic Limit chart value using expression in QlikView

Limit chart value using expression

tchovanec — Mon, 08 Dec 2014 17:19:03 GMT

I am trying to only show records that have a percent value over 5% and then show the top 10 sorted by total. I have tried using dimension limits and it doesn't give the the result I am expecting. I have attached the application and you will notice the chart is showing the top 10 by total, but there are records that have less than 5% showing. I would like this chart sorted by Total and only shows the 10 where the % is greater than 5%. Any help would be greatly appreciated. Thank you

Re: Limit chart value using expression

cspencer3 — Mon, 08 Dec 2014 17:39:45 GMT

You may want to take down that example and scramble the PHI. I believe MRN counts as PHI under HIPAA.

To solve the issue you could use the Show Values 'Greater Than' 5% relative to total. But this would show over 10 categories if there are over ten values that are greater than 5% of the total. In your example there are not.

Re: Limit chart value using expression

MK_QSL — Mon, 08 Dec 2014 17:44:41 GMT

Use expression as below

IF(COUNT(DISTINCT

FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},

DateType = {'TX_POST_DATE'},

TX_POST_DATE = P(DATE),

FLG_OSU_COST_CENTER = {0}

>}TX_ID)

COUNT(DISTINCT{<

DateType = {'TX_POST_DATE'},

TX_POST_DATE=P(DATE),

FLG_OSU_COST_CENTER = {0}

TX_ID) >= 0.1,

COUNT(DISTINCT

FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},

DateType = {'TX_POST_DATE'},

TX_POST_DATE = P(DATE),

FLG_OSU_COST_CENTER = {0}

>}TX_ID))

and

IF(COUNT(DISTINCT

FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},

DateType = {'TX_POST_DATE'},

TX_POST_DATE = P(DATE),

FLG_OSU_COST_CENTER = {0}

>}TX_ID)

COUNT(DISTINCT{<

DateType = {'TX_POST_DATE'},

TX_POST_DATE=P(DATE),

FLG_OSU_COST_CENTER = {0}

TX_ID)>=0.1, COUNT(DISTINCT

FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},

DateType = {'TX_POST_DATE'},

TX_POST_DATE = P(DATE),

FLG_OSU_COST_CENTER = {0}

>}TX_ID)

COUNT(DISTINCT{<

DateType = {'TX_POST_DATE'},

TX_POST_DATE=P(DATE),

FLG_OSU_COST_CENTER = {0}

TX_ID))

Re: Limit chart value using expression

tchovanec — Mon, 08 Dec 2014 17:44:46 GMT

Thanks for noticing the MRN. I thought I scrambled all the PHI. I have taken that down and uploaded one with MRN scrambled.

Re: Limit chart value using expression

tchovanec — Mon, 08 Dec 2014 17:49:52 GMT

Charles I tried this and when I change to use the Show Values 'Greater Than' 5% relative to total, cost centers with less than 5% still show up.

Re: Limit chart value using expression

tchovanec — Mon, 08 Dec 2014 18:56:20 GMT

Manish,

This is not working. Giving me -%'s for most of the numbers

Re: Limit chart value using expression

Mon, 08 Dec 2014 19:41:11 GMT

Hi Tom,

I think you can do something like

if(percentage > .05,

expression)

in both your total and percentage expressions that should work.

-Ray