topic Re: How to include if statement on the Label in QlikView

How to include if statement on the Label

n1ef5ng1 — Tue, 10 Mar 2015 08:04:35 GMT

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.

Re: How to include if statement on the Label

Tue, 10 Mar 2015 08:24:27 GMT

Hi,

PFA, change set expression according to your conditions.

Re: How to include if statement on the Label

n1ef5ng1 — Tue, 10 Mar 2015 08:30:00 GMT

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.

Re: How to include if statement on the Label

Tue, 10 Mar 2015 08:40:21 GMT

sum({<YYYYMM={201402},Fruits

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

>}Amount)

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

Re: How to include if statement on the Label

n1ef5ng1 — Tue, 10 Mar 2015 08:45:32 GMT

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

Re: How to include if statement on the Label

Tue, 10 Mar 2015 08:48:20 GMT

Hi,

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