Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nadig_sahana
Contributor III
Contributor III

Request help on dynamic table creation

hi all,

I am trying to create an dynamic table using 3 small source tables taken as example.But somehow it doesnt work. Can some one please look into the test file attached and guide me on this?

I have 3 tables PMM,RMM,CMM and when I try to select fields from these corresponding list boxes, a dynamic chart should be displayed.

regards,

Sahana

1 Solution

Accepted Solutions
sunny_talwar

SubStringCount() function is case sensitive (unlike Like)

You need to try these conditions for your expressions

gst amt -> =SubStringCount(Concat(DISTINCT _RMM,','),'GST AMOUNT') = 1

amt payable -> =SubStringCount(Concat(_RMM,','), 'AMOUNT PAYABLE')>=1

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

The attached sample is empty. Can you repost the document with data in it

nadig_sahana
Contributor III
Contributor III
Author

Hi Sunny,

Apologies!!

I have attached the correct file.

I have 3 list boxes PMM,RMM,CMM. When I select fields from these , simultaneously a straight table needs to generate.Please can you help?

regards,

Sahana

sunny_talwar

SubStringCount() function is case sensitive (unlike Like)

You need to try these conditions for your expressions

gst amt -> =SubStringCount(Concat(DISTINCT _RMM,','),'GST AMOUNT') = 1

amt payable -> =SubStringCount(Concat(_RMM,','), 'AMOUNT PAYABLE')>=1

Capture.PNG

View solution in original post