Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Johnnyg248
Contributor III
Contributor III

Display each individual record in details Page view format

have same question as
 
 
did not see a solution however
 
Display each individual record in details Page view format
 

Hello Team,

 

I have following requirement to search information based on the Case #.

 

  • User searches information by Case # (search can be partial or by full Case # -- basically returns multiple records)
  • Display Case # and Status in the tabular format (Can be straight table or any other best feasible format).
  • Upon clicking on any of the case# - bring up all the details associated in report view.
  • Enable option to export all the case # information into PDF file.

 

I am new to Qlik view and need to help in achieving this requirement.

Attaching the sample mockup that I am planning to achieve.

Johnnyg248_0-1598974262247.png

 

5 Replies
 
 
Johnnyg248_1-1598974262261.png

 

Johnnyg248_2-1598974262263.png

 

 Olivierrobin 
 Specialist III
   
 
 

hello

for you requirements, you can use :

1 - list box with search option

2 - table with desired columns

3 - graphs/table (whatever you need) conditionaly displayed when ONLY ON case is selected

4 - a report with these informations that could be printed as a pdf

 

 

Johnnyg248_4-1598974262264.png

 

 Balabhaskarqlik 
 Master
   
 
 
 
Johnnyg248_5-1598974262265.png

 

Johnnyg248_6-1598974262265.png

 

 Natsu_igneel 
 Contributor II
   
 
 

Hi Pujitha,

 

Can you provide some sample data so that an application is prepared?

 
Johnnyg248_7-1598974262266.png

 

Johnnyg248_8-1598974262267.png

 

 Pujitha 
 Contributor II
   
 

Hello Bala Bhaskar,

 

Thanks for response. I am basically using Qlik View, please note that, not qlik sense

 
Johnnyg248_9-1598974262267.png

 

Johnnyg248_10-1598974262268.png

 

 Pujitha 
 Contributor II
   
 

Hello Maheedhar,

 

Thank you for prompt response.

 

Below is the sample data that I am planning to generate the report.

Just to explain my requirement in more detail - When user types a search word - "CASE-AIR", all the case # that starts with CASE-AIR should be populated in the Straight Table. ( I achieved this using List Box).

 

Now, when user clicks on one of the records form the list box - All the corresponding details should be displayed in some customized format, so that user exports that report to PDF.

 

Please let me know if you have any questions.

 

   

Case #StatusCase NotesVIN #ModelYear
CASE-AIR-1234568789ActiveAir Bag not opening1234567890Buick2017
CASE-IGNITE-1234568790ResolvedIgnition Failed2345612346Cadillac2018
CASE-AIR-1234568791PendingAirbag indicator not coming up4564562324Jeep2016
CASE-DISPLAY-1234568792Need More InformationDisplay not working6783512302Wrangler2017
CASE-AIR-1234568793ActiveAir Bag not opening9002462280Chervolet2017
CASE-IGNITE-1234568794ResolvedIgnition Failed1234567890Camry2018
CASE-AIR-1234568795PendingAirbag indicator not coming up2345612346CRV2016
CASE-DISPLAY-1234568796Need More InformationDisplay not working4564562324Buick2017
CASE-AIR-1234568797ActiveAir Bag not opening6783512302Cadillac2017
CASE-INGITE-1234568798ResolvedIgnition Failed9002462280Jeep2018
CASE-AIR-1234568799PendingAirbag indicator not coming up10778250049Wrangler2016
CASE-DISPLAY-1234568800Need More InformationDisplay not working12775618923Buick2017
CASE-AIR-1234568801ActiveAir Bag not opening14772987796Cadillac2018
CASE-IGNITE-1234568802ResolvedIgnition Failed16770356670Jeep2017
CASE-AIR-1234568803PendingAirbag indicator not coming up18767725544Wrangler2018
CASE-DISPLAY-1234568804Need More InformationDisplay not working20765094417Chervolet2016
CASE-AIR-1234568805ActiveAir Bag not opening22762463291Camry
1 Reply
Brett_Bleess
Former Employee
Former Employee

I think it is going to be necessary to attach QVW file on this one, so folks can better follow the requirement and how you have setup the data model etc.  If you have sensitive data fields, you can use the Settings\Document Properties\Scrambling tab to scramble those:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Document_Proper...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.