topic Re: if condition in QlikView

if condition

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

Hi ,

I have status field as Acknowledged, transfered, resolved, closed and suspended

i am keeping filter status.

in the set analysis i have to show in the graph as

Incidents received and resolved

Formula

Received=count({<status={'Acknowledged','transfered','suspended'}>},inno)

resolved=count({<status={'resolved','closed'}>},inno)

while i am filtering with the status field the chart is not filetring as i have wriiten the calculation of status in set analysis.

i have to write in script level, can ayone please help

the user requirement is he wants to filter the status, with that he wants to see the chart to be filetred. HOw?

please help

Re: if condition

sunny_talwar — Tue, 21 Mar 2017 11:53:13 GMT

Try these

Count({<status *= {'Acknowledged','transfered','suspended'}>} inno)

Count({<status *= {'resolved','closed'}>} inno)

Implicit Set Operators

Re: if condition

mshailaja — Tue, 21 Mar 2017 12:30:22 GMT

Hi sunny

you didnt get my point.

i am using filter status in the dashboard

since i am using set analysis calculation , i cannot abl to filter with status ..

i want to do in script level

now i am filtering in the status , i cannot able to filter as i have wrote set analysis in the chart

please help

Re: if condition

sunny_talwar — Tue, 21 Mar 2017 12:31:58 GMT

Why can't you filter? How does doing it in the script would help? I am not sure I understand

Re: if condition

mshailaja — Tue, 21 Mar 2017 13:12:24 GMT

i am hardcoding in seta anlysis, thay why i cannot filter status, i want that hardcoing to be used as fileds in script level..

Formulas are

Received=count({<status={'Acknowledged','transfered','suspended'}>},inno)

resolved=count({<status={'resolved','closed'}>},inno)

Re: if condition

sunny_talwar — Tue, 21 Mar 2017 13:15:10 GMT

You should be able to filter if you use these expressions.....

Count({<status *= {'Acknowledged','transfered','suspended'}>} inno)

Count({<status *= {'resolved','closed'}>} inno)

Re: if condition

mshailaja — Tue, 21 Mar 2017 13:33:54 GMT

like this error im getting

Re: if condition

sunny_talwar — Tue, 21 Mar 2017 13:38:04 GMT

Expression editor doesn't understand the syntax, but the expression should work... Have you tried clicking okay to check if it gives the output you are hoping for?

Re: if condition

mshailaja — Tue, 21 Mar 2017 13:42:29 GMT

yes, but not working..

My actual requirement is

filetr is not working as i hardcoding in the set analysis .

i want those expressions(formaulas written in script level)

please help..

Re: if condition

sunny_talwar — Tue, 21 Mar 2017 13:48:40 GMT

Would you be able to share a sample?