Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshmanudui
Contributor II
Contributor II

How to create Adhoc reporting using field values

Hi All,

I am trying to create  adhoc report using field values.

I have fields like Products, Category, Sub Category like that.

But Category field having 3 values like Office, Infrastructure and Material.

There is no separate dimensions for Category values.

My Requirement is if I select Products then show products data and If I select Category like Office then showing Office in Separate column and if i select Infrastructure then shown in separate column and Material also having same thing .

But Office,  Infrastructure and Material there is no individual field.

I am trying to create Separate columns in Scripting side like using pick(Match)) Function.

Pick(Match(Category, 'Office'),'Office') as Office

Same thing i have created remaining values.

But it is not working properly. If i select Multiple selections in Category values then data won't be shown.

If I select single value it will work.

In the same way Sub Category also having multiple values.

Can you please suggest me how to achieve this scenario.

 

Thanks & Regards,

Lakshman

 

 

Labels (1)
2 Replies
MayilVahanan

Hi

Instead of separate fieldname, create the individual expression by using set analysis and display it based on Conditional expression.

GetselectedCount( Category ) >0 and SubStringCount(Concat(Category,'|'),'Office')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Lakshmanudui
Contributor II
Contributor II
Author

Hi Mayil Vahanan,

Thanks for your replay.

I am trying but single selections it will work, but Multiple selections it won't work.

If possible can you share example.

Thanks & Regards,

Lakshman