Percentage Issue in If Else Condition

[waqasshah]

Hi Guys,

I am trying to calculate the percentage value if specific criteria meets. I don't know why If Else condition is not working . . The charts will be my proposed output. Please review the attached screenshots. Please help.

Kind Regards

Waqas Shah

[waqasshah]

Yes That's is correct. Please note at a time on screen we show only one Speciality like surgery  25% in 2017/2018 and surgery 2018/2019 is 33.33 %.  please review screenshot for desired output (just sample).. how it can be achieved in qlikview?

[timpoismans]

Hi Waqas

It depends how you want to show one specialty.

1) You can do it through selection, thus using the measure with financial year as a dimension and the specialty selected in a listbox.

2) You can make a separate graph for a specialty and use set analysis to choose which specialty.

Do note that the second method is static.

[waqasshah]

Many Thanks are you using set Analysis?

Can you please upload the qvd file?

regards

Waqas Shah

[timpoismans · Accepted solution]

In the above screenshot, I am simple making use of a bar graph and a selection field of Specialty.

No use of Set Analysis.

I'm afraid I can't share the example file, as I'm using Qlik Sense (.qvf file vs .qvw file)

The solution works on QlikView and Qlik Sense though.

Steps to undertake:

1. Create a selection field of Specialty.
2. Make a bar graph
   1. Dimension is Financial Year
   2. Measure is: Sum(DNA)/Sum(total<DNASpecialty,[Financial Year]>DNATotal)
3. Finished.

You can now use the selection field to switch between the specialties.

If your issue is resolved, please mark the correct answer and/or any helpful answers. Thanks.

[waqasshah]

it works. Many Thanks for your help. Really Appreciated.

[timpoismans]

You're welcome!

[waqasshah]

Apologise again but the following expression you write is not set analysis ?

Sum(DNA)/Sum(total<DNASpecialty,[Financial Year]>DNATotal)

what you called it then? because it has different brackets like <> ??

[timpoismans]

No worries Waqas.

total<DNASpecialty,[Financial Year]>

is not Set Analysis, it's the total function used in a calculation.

Set Analysis is marked such as the following (in bold):

Sum({<Specialty={'Surgery'}>}DNA)

This measure would give me the sum of DNA where the Specialty = Surgery.

[waqasshah]

ok Got It many Thanks