set question ?

[Anonymous]

Hi Folks I have table like this

MINValue	MAXValue	Identifier
0	0.012	0
0.012	0.0347	1
0.0347	0.1096	2
0.1096	0.3034	3
0.3034	0.6301	4
0.6301	1.5115	5
1.5115	3.4873	6
3.4873	12.9616	7
12.9616	101	8

t2:

value	Monthnames
0	Jan-16
0.01	Feb-16
0.05	Mar-16
0.1	Apr-16
0.1	May-16
0.75	Jun-16
0.2	Jul-16
10	Aug-16
10.5	Sep-16
5.5	Nov-16
50	Dec-15
50.5	Nov-15
3.7	Oct-15
0.013	Mar-15
0.01094	Feb-15
1	Jan-15

in my chart dimension is month names and expression is

like

if (sum(value)>minvalue and sum(value)<maxvalue,,1,0)

here I don't have any association between the 2 tables

[tresesco]

What is your expected output?

[Anonymous]

IN ONE CHART

DIMENSION IS

MONTHNAMES

AND EXPRESSION  IS

if (sum(value)>minvalue and sum(value)<maxvalue,,1,0)

THIS IS NOT GIVING CORRECT VALUE

[tresesco]

qlik777 view777 wrote:

THIS IS NOT GIVING CORRECT VALUE

That I understood; and I could not understand what your CORRECT VALUE is.

[Anil_Babu_Samineni]

May be typo error. I just removed one , from your expression.

if (sum(value)>minvalue and sum(value)<maxvalue,1,0)

Can you confirm me what was the values are minvalue, maxvalue

[Anonymous]

Hi,

You can create associate key from following way:

Script:

Table1:

LOAD * INLINE [

    MINValue, MAXValue, Identifier

    0, 0.012, 0

    0.012, 0.0347, 1

    0.0347, 0.1096, 2

    0.1096, 0.3034, 3

    0.3034, 0.6301, 4

    0.6301, 1.5115, 5

    1.5115, 3.4873, 6

    3.4873, 12.9616, 7

    12.9616, 101, 8

];

table3:

LOAD *, RowNo(),MINValue as value1

Resident Table1;

DROP Table Table1;

Table2:

LOAD * INLINE [

    value, Monthnames

    0, Jan-16

    0.01, Feb-16

    0.05, Mar-16

    0.1, Apr-16

    0.1, May-16

    0.75, Jun-16

    0.2, Jul-16

    10, Aug-16

    10.5, Sep-16

    5.5, Nov-16

    50, Dec-15

    50.5, Nov-15

    3.7, Oct-15

    0.013, Mar-15

    0.01094, Feb-15

    1, Jan-15

];

table4:

load

*,RowNo()

Resident Table2;

DROP Table Table2;

Please find attached QVW for detail information and result table

[praveenkumar_s]

Can anybody tell me how to extract list from powershell

[jonathandienst]

I think you need an interval match - something like this script:

t2:

LOAD

  value

  MonthNames

FROM ...

;

Left Join(t2)

IntervalMatch(value)

LOAD MINValue, MAXValue - 1e-9 as MAXValue

FROM ...  // min - max table

;

Left Join(t2)

LOAD MINValue, MAXValue - 1e-9 as MAXValue, Identifier

FROM ...  // min - max table

;

Replace the ellipses with the correct FROM clause for your system.

[hemanthaanichet]

Hi,

I dnt know what is exact output your are in need i guess and  solved to some extend may be this is the output are in need off

Attached QVW for your reference

let me know if you have any queries

Regards

Hemanth

[Anonymous]

i want to  do this in chart expression level