topic Re: Re: Need a technique in QlikView

Need a technique

ramasaisaksoft — Wed, 17 Sep 2014 14:32:54 GMT

Hi friends/Experts,

i have a n Inline load

Load * INLINE [

service id,Service Type

1,Agency

2,Non Agency

];

Agency_Table:

agency_Name (this field is having some data)

in the Report i need to show when the user select "Agency" then straight table need to show (agency_name<>'DIRECT')

IF the user select "NON Agency" then straight table need to show (agency_name='DIRECT')

How can i achieve this result .please help me

Note:- there is no list box for Agency_Name in report

i tried like this

=if([Service Type]='Agency' and [Agency Name]<>'DIRECT',

if(([Service Type]='Non Agency' and [Agency Name]='DIRECT'),[Agency Name]))

there was no error in expression but it is not given proper result for me

if i checked for

=if([Service Type]='Agency' and [Agency Name]<>'DIRECT',[Agency Name])

it is giving proper results for this ,But if i add 2nd statement i didn't got results please help me.

In advance thanks to all experts who r helped to me.

Re: Need a technique

MK_QSL — Wed, 17 Sep 2014 14:43:12 GMT

What is your Expression?

Create a Straight Table

Dimension

agency_name

Expression (something like below, Change accordingly)

IF([Service Type] = 'Agency',SUM({<agency_name -= {'DIRECT'}>}Value),SUM({<agency_name = {'DIRECT'}>}Value))

Re: Need a technique

JonnyPoole — Wed, 17 Sep 2014 14:46:04 GMT

Does the list box for [Service Type] allow 'only 1 selected value' ? That would be important. If so i think you need to use an aggregation function to get the selected value like only ( [Service Type]) or create a variable called vSelectedServiceType with a formula =Only([Service Type])

Then in your expression you could create a calculated dimension like:

if( only([Service Type])='Agency' and [Agency Name]<>'DIRECT',[Agency Name])

if( $(vSelectedServiceType)='Agency' and [Agency Name]<>'DIRECT',[Agency Name])

The first option may need an aggr() in there but the 2nd option is better IMHO.

Re: Need a technique

MK_QSL — Wed, 17 Sep 2014 14:47:19 GMT

Check enclosed file...

Re: Need a technique

cspencer3 — Wed, 17 Sep 2014 19:06:49 GMT

You could use the GetFieldSelections() function to determine what is selected in that list box. Then in your expression or calculated dimension do something such as :

if(GetFieldSelections(ServiceType,';',10) = 'Agency', TRUE STATEMENT, FALSE STATEMENT) . You could also nest this If statement if necessary to accommodate more values.

Re: Need a technique

ramasaisaksoft — Thu, 18 Sep 2014 06:47:45 GMT

please check above attachments for better understanding,

here i need if user selects "Agency" then straight table chart needs to show data without "direct" agency

if the user selects"Non Agency " then straight table chart needs to show data which is "Direct" agency .

please help me.

Re: Re: Need a technique

cspencer3 — Thu, 18 Sep 2014 14:30:06 GMT

I have implemented the logic i created earlier to edit your QVW. Take a look at the expression and how the table changes when you select a value in the Agency/Non-Agency Field.