topic Re: Design Dashboard using multiple Campaigns in QlikView

Design Dashboard using multiple Campaigns

vikasmahajan — Fri, 27 Nov 2015 05:03:28 GMT

Dear all,

I have following fileds of Campaign in drop down multibox

%CampaignJobFunction

---------------------

Cross Job Function

Cross Function

When user will select Campaign , then all data related to Campaign will be display in dashboard dynamically

Please find sample Campaign.xls file attached.

Reards

Vikas

Re: Design Dashboard using multiple Campaigns

Anonymous — Fri, 27 Nov 2015 05:08:25 GMT

What's your problem?

This is the default functionality of QV whatever you select, if it is associate you will get that..

Re: Design Dashboard using multiple Campaigns

vikasmahajan — Fri, 27 Nov 2015 05:23:11 GMT

I have data loaded with table name.field name in my data model for example abc.CampaignJobFunction ,abc1.CampaignJobFunction,abc2.CampaignJ6obFunction etc then when user select abc.CampaignJobFunction from drop down then fileds of abc table will be display in dashboard.

Any Idea how to design such dashboards ?

Vikas

Re: Design Dashboard using multiple Campaigns

Anonymous — Fri, 27 Nov 2015 05:27:47 GMT

It seems you are asking for Conditional Hide and Show of fileds on the base of selections. is it?

http://www.learnqlickview.com/the-conditional-show-in-qlikview/

Re: Design Dashboard using multiple Campaigns

Anonymous — Fri, 27 Nov 2015 05:34:20 GMT

Is this you are asking?

Re: Design Dashboard using multiple Campaigns

vikasmahajan — Fri, 27 Nov 2015 05:36:28 GMT

I want to store campaign into var1,var2,var3 then as per user selection I want to design dashboard, as you say show and hide will be here for pivot tables but how to store fields selected by user into variable and use this variable in dashboard dynamically

Vikas