Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Re: How to remove circular reference

Thanks for your solution

But in my case I am not using expression. It is like I will be having a button to swap between different type of date.

Initially I will show the date from "yyy" table and will make selection on that date field and click on the button to change to the objects using date from "xxx" table. So in table yyy if I select 2013-01-27 date and change to the "xxx" table date, it will have a multi-box which will show the date range like "2013-01-15 - 2013-02-28".

To achieve this only I have used IntervalMatch, whether we can use anything else to achieve this??

I have attached a sample on how it will work in layout.

Thanks,

Leni Balakrishnan

Highlighted
Creator III
Creator III

Re: How to remove circular reference

Hello Leni,

  Still your data model is having Synthetic keys. (Please see the image which I had posted to your reply)

You can rename your fields of date which are coming from XXX and YYY table. Avoid the synthetic keys.

Yes, you can use Set Analysis for the same instead of intervalmatch. (Steve has mentioned in the above post).

Thanks

Advait

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
Highlighted
Not applicable

Re: How to remove circular reference

Hi,

Varify resource utilization, if ram usage is more,  then try to drop tables that are no longer used in the script.

Niranjan M.

Highlighted
Creator III
Creator III

Re: How to remove circular reference

Hi Advait,

Can you help by modifying my sample using set analysis?? As I don't know how to use in my requirement.

Thanks in advance

Thanks,

Leni

Highlighted
Creator III
Creator III

Re: How to remove circular reference

I have achieved this requirement by using the expression suggested by steve.

Thanks steve.

I have attached the modified file.

Thanks all for the help.

~Leni