topic Re: Need Help on Qlikview Functionality in QlikView

Need Help on Qlikview Functionality

Anonymous — Thu, 02 Jul 2015 09:59:57 GMT

Hi Team,

I have a filters like Year, Quarter , Month, Agent and Country .I selected the A1 in agent filter, Japan in Country , 2015 in year filter and q3 from quarter filter Normally it clears the filter selections but I want to display 'no Data' and won't clear the filter selections
Please team help me it is an urgent requirement in my project plsssss.

Thanks in advance

Best Regards

Anusha K

Re: Need Help on Qlikview Functionality

QlikAngel — Thu, 02 Jul 2015 10:04:43 GMT

If want to show the message to users then in chart properties ---> Error Message ---> calculation condition unfulfilled

type message whatever you want to show

Re: Need Help on Qlikview Functionality

MK_QSL — Thu, 02 Jul 2015 10:04:56 GMT

Not clear from your explanation. Can your provide little more information?

Re: Need Help on Qlikview Functionality

Thu, 02 Jul 2015 10:08:10 GMT

Can you elaborate the requirement. If possible attach sample QVW. And this is similar to below thread. Please refer.

Qlikview Functionality

Regards,

KKR

kumar_ilb‌

Re: Need Help on Qlikview Functionality

Anonymous — Thu, 02 Jul 2015 10:11:00 GMT

hi manish,

If we selected unassociated values in filter it clears the all selections in my application for example in my application 2015 has till june data available .if I select 2015 and aug month it clears the year filter .I don't want to clear the selection .If the particular selection has no association with the before selected filter values it has to display message like 'no data' instead of clearing the filter selections

Re: Need Help on Qlikview Functionality

avinashelite — Thu, 02 Jul 2015 10:12:02 GMT

Hi Anusha,

This is because the selection your making are not relevant i.e say for Japan sales is on 2013 and your trying to apply japan filter first and then 2014 on top of that....then it will clear the previous filter..because 2014 japan does not have data...

if you dont want to clear the previous filter than use the locking feature ...once you apply the filter right click lock ...this will help you

Re: Need Help on Qlikview Functionality

Anonymous — Thu, 02 Jul 2015 10:12:27 GMT

Yes exactly same requirement kranthikumar.

Re: Need Help on Qlikview Functionality

Anonymous — Thu, 02 Jul 2015 10:14:30 GMT

Thanks avinash for your response but locking is not the solution for my requirement.

Re: Need Help on Qlikview Functionality

MK_QSL — Thu, 02 Jul 2015 10:14:48 GMT

Don't know the solution but you can hide the unassociated data by using below expression as list box expression to create list box

=Aggr(Year,Year)

=Aggr(Month,Month)

Re: Need Help on Qlikview Functionality

Anonymous — Thu, 02 Jul 2015 10:17:00 GMT

Thankyou Manish for your reply but we don't want to hide excluded values .we have to show excluded values

Re: Need Help on Qlikview Functionality

avinashelite — Thu, 02 Jul 2015 10:19:43 GMT

Ya Anusha your rite but this how qlikview is designed ...if you want like that..then you need to populate missing data with null values..thats the only solution

Re: Need Help on Qlikview Functionality

settu_periasamy — Thu, 02 Jul 2015 10:37:08 GMT

Hi,

This is just a suggestion. Still, if you need to do that requirement, you have to create island table for the fields.

find the attached may be give the idea.