topic Re: how to write dynamic expression in QlikView

how to write dynamic expression

kunkumnaveen — Mon, 04 Apr 2016 06:15:59 GMT

Hello all , if i have a sample data like ,how to write a dynamics expression

category decision material lot

smelting accepted spix 10

smelting rejected spix 20

smelting exception spix 30

mining accepted hydra 25

mining rejected hydra 35

mining exception hydra 45

so i need a dynamic expression : category={smelting},decision={accepted } and that particular material lot = 10 in percentage

category={smelting} total lot (10+20+30)

thanks

naveen

Re: how to write dynamic expression

kunkumnaveen — Mon, 04 Apr 2016 06:19:27 GMT

category={smelting},decision={accepted } and that particular material lot = 10 in percentage

category={smelting} total lot (10+20+30)

Re: how to write dynamic expression

tamilarasu — Mon, 04 Apr 2016 06:24:05 GMT

Hi,

Try this

=Num(Sum({<[category]={'smelting'},[decision]={'accepted'}>}lot) / Sum(Total {<category={'smelting'}>}lot), '#,##0.00%')

Re: how to write dynamic expression

kunkumnaveen — Mon, 04 Apr 2016 06:31:20 GMT

dude i need dynamic expression...see that category and decision fields i need dynamic ,

what i mean is those fields has to change based up on user selection ,,i just wrote like that for better understanding purpose

Re: how to write dynamic expression

jonathandienst — Mon, 04 Apr 2016 06:32:02 GMT

Like this perhaps (assuming that this is in a text box or similar undimensioned location):

Sum({<category = {'smelting'}, decision = {'accepted'}>} lot) / Sum({<category = {'smelting'}>} lot)

How do you want to use user selections?

Re: how to write dynamic expression

jonathandienst — Mon, 04 Apr 2016 06:35:31 GMT

If you mean let the user select a category, then use:

Sum({<decision = {'accepted'}>} lot) / Sum(lot)

Re: how to write dynamic expression

jonathandienst — Mon, 04 Apr 2016 06:37:47 GMT

If you mean the user will select both fields:

Sum({<category = P(category), decision = P(decision)>} lot) / Sum({<category = P(category)>} lot)

Sum({<category = P(category), decision = P(decision)>} lot) / Sum({<category = P(category), decision>} lot)

Re: how to write dynamic expression

tamilarasu — Mon, 04 Apr 2016 06:38:17 GMT

Could you post expected output for the above data.?

Re: how to write dynamic expression

kunkumnaveen — Mon, 04 Apr 2016 06:40:23 GMT

I am showing this requirement in combo chart

Sum({<category = {'smelting'}, decision = {'accepted'}>} lot) / Sum({<category = {'smelting'}>} lot)

can this expression be a dynamic

Sum({<category = {''}, decision = {''}>} lot) / Sum({<category = {''}>} lot)

those category should change based up on user selection i mean so time it may be smelting or mining or -----------(i got 10 diff values in that filed)

and the same with decision field ..i need that also dynamic

Re: how to write dynamic expression

kunkumnaveen — Mon, 04 Apr 2016 06:45:44 GMT

user will select both category and decision then it will bring to other chart(combo chart) there material will be dimesion...

Re: how to write dynamic expression

Kushal_Chawda — Mon, 04 Apr 2016 06:49:43 GMT

If you want dynamic, based on selection then create two variables on front end

vCategory = concat (distinct chr(39) category chr(39) ,',')

vDecision = concat (distinct chr(39) decision chr(39) ,',')

Now write the expression

Sum({<category = {$(vCategory)}, decision = {$(vDecision)}>} lot) / Sum({<category = {$(vCategory)}>} lot)

Sum({<category *= {$(vCategory)}, decision *= {"$(vDecision)"}>} lot) / Sum({<category *= {$(vCategory)}>} lot)

Expression will show error but it will work

Edit: remove " from set

Re: how to write dynamic expression

t_chetirbok — Mon, 04 Apr 2016 07:22:07 GMT

hi!

try this num(sum(lot)/sum(TOTAL{<decision=>} lot),'#,##0%')