How to include if statement on the Label

[n1ef5ng1]

Hi all,

I have stuck this for awhile. On the attached, (capture.jpg). This is a chart that I would like to achieve in QV. I did this capture.jpg through qlikview using label expression where i compute the % in label expression.

However I am stuck on creating a replica of the chart with a more complicated formula. Attached sample is @ Sample.qvw. ignore the indicator field as there isnt any indicator field in the real database, it is just to assist on what are the fields that should be included in the chart.

Criteria text box is the criteria that i have set for the line chart, this is done through dimension, However I would like to compute the value of each month in the label box. However I am stuck in it. The data file should assist in understanding the problem.

Thanks.

[#2]

Hi,

PFA, change set expression according to your conditions.

[n1ef5ng1]

thanks but the number is different... i.e 201501 for yours is 128 but actual is 98 due to some if statement that is needed to fit it in.

[#4]

sum({<YYYYMM={201402},Fruits

={'Apple','Orange'},Service={'AM1','AM2'}>+<YYYYMM={201402},Name={'MS1','MS2'},Service={'OTH'}

>}Amount)

..............Try this

[n1ef5ng1]

Doesn work... may i know what does >+< means? diden came across this before...

[#6 · Accepted solution]

Hi,

Check the attached app. '+' is acting as OR operator.