Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
narayanaqlik
Creator
Creator

how to make the default selections inPick(Match()) ?

Hi All,

I have requirement like, i am using one pie , line , gauge charts for different calculations  for different categories calculations.

here i have one drop down button(list box) has contain Project, Country,Vendor,Trial as selection options

Here i have created different objects for different categories and placed in container based on selections corresponding get displayed and default display is Project.

But My requirement is i need incorporate for all categories calculations in a single pie chart, single Line chart... based on the selection of drop down calculations should be changed.

i have written an expression like by using pick(Match) like the below but not working for default selections 

Pick(1 + Match(Category,'Project','Country','Vendor','Trial')

,Others,Project,Country,Vendor,Trial)

here if i am not selecting anything it is displaying -, i am selecting Project from drop down then it is showing then it is displaying Project like the way Country, Vendor, Trial

Kindly  any one help in this

Please give me the good Expression here Thanks a lot in advance... 

 

 

1 Solution

Accepted Solutions
narayanaqlik
Creator
Creator
Author

Hi Dear all,

Answer for the above question

Thanks for trying to help me but i got the answer if you want you can use in your projects as well if you have any requirement like this

create a variable in frontend side like 

varFieldvalue=GetFieldSelections(FieldName)

Pick(1 + FieldIndex('FieldName',(varFieldvalue)),'DefaultValue','Project','Country','Vendor','Trial')

View solution in original post

1 Reply
narayanaqlik
Creator
Creator
Author

Hi Dear all,

Answer for the above question

Thanks for trying to help me but i got the answer if you want you can use in your projects as well if you have any requirement like this

create a variable in frontend side like 

varFieldvalue=GetFieldSelections(FieldName)

Pick(1 + FieldIndex('FieldName',(varFieldvalue)),'DefaultValue','Project','Country','Vendor','Trial')