Design Dashboard using multiple Campaigns

[vikasmahajan]

Dear all,

I have following fileds of Campaign  in drop down multibox

%CampaignJobFunction

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

Cross Job Function

IT

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

[Anonymous]

What's your problem?

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

[vikasmahajan]

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

[Anonymous]

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/

[Anonymous]

Is this you are asking?

[vikasmahajan]

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

[Anonymous]

this might help you?

Set trigger to select multiple values in a field from a variable

Store selected field value in variable

Dynamic Field Expressions with Variables

http://stackoverflow.com/questions/25513812/creating-variable-during-load-script-in-qlikview

[Kushal_Chawda]

create the inline table

Field:

load * inline [

Field

abc.Campaign

abc1.Campaign

abc2.Cappaign ];

Now select the Field values

Create the listbox or calculated dimension in chart

if(Field='abc.Campaign',abc.Campaign,

if(Field='abc1.Campaign',abc1.Campaign,

if(Field='abc2.Campaign',abc2.Campaign)))