topic Re: comparing Field Values in an if statement in QlikView

comparing Field Values in an if statement

naveen341 — Sat, 16 Nov 2024 05:11:52 GMT

I Have a field

Tickers :

AAA

ACB

BCG

CDG

Suppose if a user select particular tickets lets say AAA i want to perform the measure like sum({<Ticker={'AAA'}>}Sales).

this would be in a qliksense line chart

If a user says more than one field values i am expecting multiple line in the line chart how can this be acheived?

I Am looking for if condition like getfieldselection(Ticker).But if multiple selected in differnet order this is not working

Any help would be appreciated

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 21:12:30 GMT

as i understand you want the individual ticker line only if a ticker is selected. Else you show just the total line. Is that right?
if so Why dont you add ticker as a dimension? and Enable it conditionally e.g. GetSelectedCount(Ticker)>0

Re: comparing Field Values in an if statement

naveen341 — Mon, 19 Nov 2018 21:15:12 GMT

I Am trying to do it in Qliksense using an extenison where i dont have a conditional dimenison.
So i would like to write an if condition and put the measure value,
getfield values(Ticker)=AAA,ACB
BUt how can i implement if condition for measure

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 21:19:55 GMT

Ah.. i just saw the qlik sense part. You posted on the qlikview forums hence the confusion.

May not be a perfect solution but below should work
add dimension
=If(GetSelectedCount(Ticker)>0,Ticker)

Re: comparing Field Values in an if statement

naveen341 — Mon, 19 Nov 2018 21:37:25 GMT

Sorry .i want to compare field values and then perform my measure based on field value .Not the count

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 21:45:31 GMT

What do you mean by not count? I am not displaying count
The calculated dimension I mentioned will be enabled only if 1 or more ticker is selected. I.e. you will get lines for those tickers on your chart.

Re: comparing Field Values in an if statement

naveen341 — Mon, 19 Nov 2018 21:56:00 GMT

Each ticker has different Measure.
if(Getfieldvalue(Ticker)='ABC',min(Sales),Null),
If multiple field values are selected how can i write the above if condition.

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 22:05:06 GMT

Ok. So you are not displaying same measure for different tickers.i.e. e.g. for ticker abc it maybe count and got ticker xyz it maybe sum.
Did I get that right?

Re: comparing Field Values in an if statement

naveen341 — Mon, 19 Nov 2018 22:09:08 GMT

yes

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 22:14:53 GMT

In that case of the top of my head.
you maybe able to use concat(ticker) to get the full list of possible values for ticker and use string functions to check if e.g. and exists there. And use get selected count to ensure at least 1 is selected

Replying from phone so forgive typos

Re: comparing Field Values in an if statement

dplr-rn — Mon, 19 Nov 2018 22:24:40 GMT

Basically something like.
If(getselectedcount(ticker)>0 and
SubStringCount(concat(ticker,'-'),'abc')>0
, Expression-for-abc)

Re: comparing Field Values in an if statement

naveen341 — Tue, 20 Nov 2018 14:39:19 GMT

Nope its not working.
Here is the screen shot like if multiple values are selected how will i check in if condition.

Re: comparing Field Values in an if statement

naveen341 — Tue, 20 Nov 2018 14:41:52 GMT

Atleast screen shot to original thread.Capture.pNG

Re: comparing Field Values in an if statement

dplr-rn — Tue, 20 Nov 2018 14:50:19 GMT

You are doing a wild match get field selections.

I would do wildmatch on the output of concat function

Re: comparing Field Values in an if statement

dplr-rn — Tue, 20 Nov 2018 16:43:03 GMT

Basically create multiple meaures each with the condition for ticker and appropriate measure