Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aass0917
New Contributor

条件を絞った表示についてお教え下さい

Sum([売上実績])/Sum([目標値])   で達成率を求めて、

更に100%以上、80%~99%、70%以下などの

条件を絞って表示させる方法をご教示頂けますと幸いです。

1 Reply
arvind654
Honored Contributor II

Re: 条件を絞った表示についてお教え下さい

Translate into English please?

below translation is correct..?

By finding the achievement rate with Sum ([Sales Results]) / Sum ([Target Value]),

Furthermore 100% or more, 80% to 99%, 70% or less of

It would be greatly appreciated if you could tell me how to narrow down the conditions.