Calculate percent in line chart - calculated dimension

[#1]

Hi there,

I need to create a line chart that shows proportional percentages across the chart (i.e. the % should add up to 100)

The calculated dimension is:

=If([Duration]>Time('0:30:00','h:mm:ss'),
  IF([Type]='Type1',Hour([Start Time])))

Expression (returns incorrect value):

count([PrimaryKey]) / count(TOTAL [PrimaryKey])

I tried using set analysis but only suceeded partly. The condition for [Type] works but not for [Duration]:

count([PrimaryKey]) / count(TOTAL {<Type={'Type1'}, [Duration]={">Time('0:15:00','h:mm:ss')"}>} [PrimaryKey])

Appreciate your responses, thanks!

[its_anandrjs]

Try it like

count([PrimaryKey])

/

count(TOTAL {<Type={'Type1'}, [Duration]={">$(=Time('0:15:00','h:mm:ss') )" }>} [PrimaryKey])

Regards

Anand

[its_anandrjs]

And another one is

count([PrimaryKey])

/

count(TOTAL {<Type={'Type1'}, [Duration]={'>$(=Time('0:15:00','h:mm:ss') )'}>} [PrimaryKey])

Regards

Anand

[Anonymous]

hi,

Please refer to below post:

http://community.qlik.com/message/156954#156954

Regards

Neetha

[#5]

Hi Anand,

Thanks for your responses. I tried both methods and even assigned =Time('0:15:00','h:mm:ss') to a variable (hoping that might help). Unfortunately none of the options work. "No data to display" is the message shown on the chart.

[#6]

Hi Neetha,

I'm using the TOTAL keyword but it doesn't work in my case because I have a calculated dimension. It looks like the person in the link you provided isn't using a calculated dimension.

Maybe I'm missing something?

Thanks.

[Anonymous]

Hi Aviral,

Please try by creating new expression in expression tab:

count([PrimaryKey])/count(TOTAL {<Type={'Type1'}, [Duration]={'>$(=Time('0:15:00','h:mm:ss') )'}>} [PrimaryKey])

Check relative button (or) Number Tab -  Select fixed option and check show in percent option.

Regards

Neetha