topic Filter criteria in QlikView

Filter criteria

varunreddy — Wed, 27 Apr 2016 19:53:51 GMT

Hi all,

I have created the calculation dimension.

Calculation Used:

aggr(only({<[As of Date]={'$(vmaxweek)','$(vprevWeek)'}>}[As of Date]),[As of Date])

vmaxweek - =max({1<[Pull Type]= {'W'}>}[As of Date])

This always stores the latest available date

prevWeek - =max({<[As of Date] -= {'$(vmaxweek)'},[Pull Type]= {'W'}>}[As of Date] )

This will pick and store the date on selection and displays the previous date availbale for the most available date by default

When nothing is selected the report is showing bars for latest date and the previous available date. The problem is, when I select the date filter, the bar is showing only one value. the bar is not showing latest date vailable.

Can anyone guide me through this process?

Thanks in advance!

Regards,

Varun

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:02:06 GMT

Try adding a one here:

Aggr(Only({1<[As of Date]={'$(vmaxweek)','$(vprevWeek)'}>}[As of Date]),[As of Date])

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:03:35 GMT

Sunny,

Tried this. Not working. Still ignorning vmaxweek

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:05:16 GMT

Is your As of Date field in Number format? The reason I asked this is because you are using Max() and haven't added the Date() function. May be you need to add Date() with the format to make it work?

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:09:25 GMT

I guess you need to ignore selection in [As of Date] field in your expression using set analysis for this to work:

{<[As of Date]>}

UPDATE: The issue is that although your dimension wants to show two dates, your expression is only available for the selected date because it has not been told to not filter based on selection in date field. Once it is told to ignore selection, it will always display for all dates, but now the dimension won't let you see anything more than the two dates. I hope this make sense.

Best,

Sunny

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:13:48 GMT

Sunny,

Thanks. Ignoring selection in the expression worked. I was trying it with dimension, that might be the reason why it didn't work for me.

Cheers!

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:14:52 GMT

Sunny,

I am using three dimensions and I am able to see lable for first and third. I am unable to see second. Have you come across this situation?

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:15:38 GMT

Can you share a screenshot?

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:47:42 GMT

Actually I cannot share the screenshot.

If I select particular dimension (Primary) I am able to see secondary dimension. If I clear the selections I cannot see the secondary dimensions.

Primary dimensions is shown 10 at a time using x-axis scroll bar. It has around 30 values.

Hope this helps.

I will try to send you screen shot with mock up data

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:51:10 GMT

Is Secondary dimension the Aggr() dimension or is it somehow dependent on the first one?

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:52:59 GMT

Aggr dimension

Re: Filter criteria

sunny_talwar — Wed, 27 Apr 2016 20:56:45 GMT

See if adding the Primary dimension to your Aggr() function helps:

Aggr(Only({<[As of Date]={'$(vmaxweek)','$(vprevWeek)'}>}[As of Date]),[As of Date], PrimaryDimension)

Re: Filter criteria

varunreddy — Wed, 27 Apr 2016 20:59:38 GMT

Sunny I found alternative. I changed the style of the graph. I think it was not showing because of too many values and it was not having sufficient space to display.

Thanks for your help.

Cheers!