restrict specific values in set analysis in a Chart

Sun, 20 Oct 2013 12:59:55 GMT

Hi All,

I have a bar chart with 1 dimension that counts something per each value in the dimension.

I have a set analysis expression: Sum({<RUN_ID={$(vMax_Run)},OPCODE, FLOW={"*"}-{0}>} COUNT_A*COUNT_B)

I want to restrict the chartto show only several values from 'OPCODE' and not all the values.

and I want them to be in an order that I choose.

I tried to write: Sum({<RUN_ID={$(vMax_Run)},OPCODE={'A','C','E'}, FLOW={"*"}-{0}>} COUNT_A*COUNT_B)

I didn't work

How can I do it?

Thanks,

Boris

Re: restrict specific values in set analysis in a Chart

Gysbert_Wassenaar — Mon, 21 Oct 2013 11:55:28 GMT

You can't define a sort order in a set modifier. If you want the result show in a specific order in the bar chart then you need to either create the sort order in the script or sort by an expression like =match(only({1}OPCODE),'A','C','E')

topic Re: restrict specific values in set analysis in a Chart in QlikView

restrict specific values in set analysis in a Chart

Re: restrict specific values in set analysis in a Chart