topic Re: variable with "And" in QlikView

variable with "And"

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want to use And with variable below is my expression giving wrong result.

logic: if(qtr=MaxQtr and qtr =qtr, frcst+act)

if(Quarter=vMaxQtr and Quarter=Quarter,$(vFc)+$(vAc))

how to write this in correct way?

thanks

chanty

Re: variable with "And"

dapostolopoylos — Mon, 23 Jul 2018 11:30:59 GMT

Try this:

if(Quarter=vMaxQtr and Quarter=Quarter,'$(vFc)'+'$(vAc)')

Re: variable with "And"

Chanty4u — Mon, 23 Jul 2018 11:34:08 GMT

Not working

Re: variable with "And"

sunny_talwar — Mon, 23 Jul 2018 11:37:49 GMT

What is Quarter = Quarter means? On a single row... Quarter will always equal to Quarter....

Re: variable with "And"

Chanty4u — Mon, 23 Jul 2018 11:39:12 GMT

logic is the selection is multiple values then sum

it means maxquarter and anyother quarter

example: 2018Q3+ any quarter selected else part should take

Re: variable with "And"

sunny_talwar — Mon, 23 Jul 2018 11:42:10 GMT

Chanty bhai, I have no idea what you are trying to say.... do you want to may be share few rows of dummy data to show what you have and what you are looking to do with it?

Re: variable with "And"

Chanty4u — Mon, 23 Jul 2018 11:58:08 GMT

i have quarter field values

2018Q3

2018Q2

2018Q1

---

2017Q3

so when user selected two quarters from the listbox the else part should work

Re: variable with "And"

sunny_talwar — Mon, 23 Jul 2018 11:59:45 GMT

Still not helpful

Re: variable with "And"

pintucs20 — Thu, 26 Jul 2018 14:07:46 GMT

Hi ,

try this

sum({<Quarter={'vMaxQtr','Quarter'}>}($(vFc)+$(vAc)))