topic Re: function equal to inline in QlikView

function equal to inline

qv_jagan — Thu, 21 Feb 2013 11:23:38 GMT

Hi all,

I have the following data

Date	A	B	C
1	1	16	31
2	2	17	32
3	3	18	33
4	4	19	34
5	5	20	35
6	6	21	36
7	7	22	37
8	8	23	38
9	9	24	39
10	10	25	40
11	11	26	41
12	12	27	42
13	13	28	43
14	14	29	44
15	15	30	45

I want to create a chart like the one shown below

I used an Inline function to create the column FY in the chart.

LOAD

* INLINE [
F1
Rev
Vol
eVol
]

;

expression used in column name 1 in the chart was

IF(F1='Rev',Sum({< Date={1}>} A),

IF(F1='Vol',Sum({< Date={1}>} B),

IF(F1='eVol',Sum({< Date={1}>}C)

 )))

I want to know the equivalent function for the inline function at the ui side inorder to create a dummy values for a column that can be used in charts.

Please advice.

I have also attached the file.

Thanks in advance.

Re: function equal to inline

qv_jagan — Thu, 21 Feb 2013 11:26:09 GMT

I want to know the equivalent function for the inline function at the ui side inorder to create a dummy values for a row at Dimension side that can be used in charts.

Re: function equal to inline

Gysbert_Wassenaar — Thu, 21 Feb 2013 11:33:15 GMT

The valuelist function is what you're looking for I think. You can create a calculated dimension with dummy values using valuelist: valuelist('dummy1','dummy2','dummy3'). You'll have to use it in expressions too:

if(valuelist('dummy1','dummy2','dummy3')='dummy1', expr1,

if(valuelist('dummy1','dummy2','dummy3')='dummy2', expr2,

if(valuelist('dummy1','dummy2','dummy3')='dummy3', expr3)))

Re: function equal to inline

qv_jagan — Thu, 21 Feb 2013 11:57:02 GMT

Thanks a lot for the answer.

Just FYI... It can also be done like this.