Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
Champion III
Champion III

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

View solution in original post

Chanty4u
Champion III
Champion III

Not working

sunny_talwar

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

Chanty4u
Champion III
Champion III

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
Champion III
Champion III

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)))