topic Filter Expression need to check in QlikView

Filter Expression need to check

Tue, 05 Apr 2016 07:03:43 GMT

Hi Folks,

I have a FIlter i.e., Time

Time

-------

Quarter

Week

When i select Quarter it shows Monthly Data.

When i select Week its want to show Week only, But here it was not showing weekly. Its showing Monthly, i want to correct it.

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,

If(GetFieldSelections(FilterFreq)='Weekly',WeekFlag,QuarterFlag))

is it correct? can you check and help? -- its not working correctly..

Sub2u444

Re: Filter Expression need to check

kkkumar82 — Tue, 05 Apr 2016 07:09:06 GMT

If Iam correct your default value is Quarter otherwise,

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,,WeekFlag,QuarterFlag)

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,'Weekly')

this would be fine

Kiran Kumar

Re: Filter Expression need to check

Chanty4u — Tue, 05 Apr 2016 07:10:23 GMT

correction.

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,WeekFlag,QuarterFlag)

Re: Filter Expression need to check

tamilarasu — Tue, 05 Apr 2016 07:28:22 GMT

Hi,

Try,

If(GetFieldSelections(FilterFreq)='Weekly', WeekFlag, QuarterFlag)

If nothing selected then QuarterFlag will be displayed by default.

Re: Filter Expression need to check

Tue, 05 Apr 2016 07:29:01 GMT

Hi,

Its not working, If allow only 2 values after checking the condition.

Its not accepting 3rd value.

Sub2u444

Re: Filter Expression need to check

kkkumar82 — Tue, 05 Apr 2016 07:32:35 GMT

Hi,

Can you be clear on what you want, upload some sample data and explain your requirement better.

Re: Filter Expression need to check

HirisH_V7 — Tue, 05 Apr 2016 07:35:53 GMT

Hi,

You can use set analysis , Are you using this in chart?

else

you can modify your expression like this,

if(GetFieldSelections(FilterFreq)='Weekly',WeekFlag,QuarterFlag)

HTH,

Hirish

Re: Filter Expression need to check

Tue, 05 Apr 2016 07:37:40 GMT

Hi Kiran,

It was not working. Instead of WeekFlag it shows 'Weekly'..

SUb2u444

Re: Filter Expression need to check

kkkumar82 — Tue, 05 Apr 2016 08:30:25 GMT

I think the if condition must be changed

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,'WeekFlag')

Do you have WeekFlag field then it should work.

Otherwise check the values in FilterFreq column , then change the condition accordingly.

Thanks

Kiran Kumar

Re: Filter Expression need to check

Tue, 05 Apr 2016 08:56:16 GMT

Hi Hirish,

Yes, i am using in Bar Chart.

Bar Chart Expr:- If(GetSelectedCount(QuarterFlag)>0,MonthFlag,WeekFlag)

Filter Expr:-

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,

If(GetFieldSelections(FilterFreq)='Weekly',WeekFlag,QuarterFlag))

when i select in Week in Filter - Bar Chart shows Monthly Data.

Sub2u444

Re: Filter Expression need to check

Tue, 05 Apr 2016 08:57:18 GMT

Hi Kiran Kumar,

sorry unable to share, i have little bit urgent..

Thanks for your quick response..

Sub2u444

Re: Filter Expression need to check

Tue, 05 Apr 2016 08:59:01 GMT

Hi Nagaraj,

I used above one, but it shows wrong.

i shared the expr's what ever i used in my app

Sub2u444

Re: Filter Expression need to check

Kushal_Chawda — Tue, 05 Apr 2016 09:06:32 GMT

Put below expression in bar chart

If(GetFieldSelections(FilterFreq)='Quarterly',QuarterFlag,

If(GetFieldSelections(FilterFreq)='Weekly',WeekFlag,QuarterFlag))

Re: Filter Expression need to check

Tue, 05 Apr 2016 09:16:34 GMT

Thanks for the reply, i already check with this also. But not working.

Let me share some more info..

LOAD * INLINE

[FilterFreq,

Quarterly,

Weekly

];

Load

Ticket

,.............other fields....

,WeekFlag

,MonthFlag

,QuarterFlag

Resident Final

Order by Period;

This my script

Re: Filter Expression need to check

Kushal_Chawda — Tue, 05 Apr 2016 09:21:33 GMT

What dimension and expression you are using in bar chart? what you want to display on bar chart?

Re: Filter Expression need to check

Tue, 05 Apr 2016 09:25:38 GMT

Based on Time Bucket - Quarterly / Weekly (Dimensions)

Expr :- Count(Ticket)

Ex:- If i select Quarterly -> It shows Monthly

If i select Weekly -> It shows Weekly based on selection i.e., single/multiple..

Sub2u444

Re: Filter Expression need to check

Kushal_Chawda — Tue, 05 Apr 2016 09:38:48 GMT

create calculated dimension as like below

=aggr( if(FilterFreq='Quarterly', only(QuarterFlag),

if(FilterFreq='Weekly', only(WeekFlag),only(QuarterFlag))), QuarterFlag,WeekFlag)

if(FilterFreq='Quarterly', QuarterFlag,

if(FilterFreq='Weekly', WeekFlag,QuarterFlag))

Re: Filter Expression need to check

Kushal_Chawda — Tue, 05 Apr 2016 09:49:06 GMT

Or i think best way is do the conditional

add two dimension in your char

1) QuarterFlag

2) WeekFlag

Now for QuarterFlag dimension write the enable conditional expression as

= if(getselectedcount(FilterFreq)=0 or FilterFreq='Quarterly',1,0)

for WeeklyFlag dimension write the below enable conditional expression

= if(FilterFreq='Weekly',1,0)

So when you will select Quarterly or nothing is selected dimension will be QuarterFlag and when you will select the Weekly dimension will be WeeklyFlag

Re: Filter Expression need to check

Tue, 05 Apr 2016 11:38:59 GMT

hi try this it's so simple

If(match(FilterFreq,'Quarterly'),QuarterFlag,

If(match(FilterFreq,'Weekly'),WeekFlag,QuarterFlag))

as per selection on filterfreq field it check this condition and give appropriate flag fields.

Re: Filter Expression need to check

Tue, 05 Apr 2016 17:26:46 GMT

Hi Vijay,

Thanks for reply. I tried the same, it was showing some discrepancy like below

when i select Quarter > It shows like Q4-FY2015...

Wee k > 10/16/2015....

Sub2u444‌