Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

variable with "And"

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

1 Solution

Accepted Solutions
dapostolopoylos
Creator III
Creator III

Try this:

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

Father/Husband/BI Developer

View solution in original post

8 Replies
dapostolopoylos
Creator III
Creator III

Try this:

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

Father/Husband/BI Developer
Chanty4u
MVP
MVP
Author

Not working

sunny_talwar

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

Chanty4u
MVP
MVP
Author

logic is    the selection is   multiple values  then sum

it means  maxquarter and anyother quarter

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

sunny_talwar

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?

Chanty4u
MVP
MVP
Author

i have quarter field values

2018Q3

2018Q2

2018Q1

--

---

2017Q3

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

sunny_talwar

Still not helpful

pintucs20
Contributor III
Contributor III

Hi ,

try this

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