Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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