topic Request help on dynamic table creation in QlikView

Request help on dynamic table creation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Request help on dynamic table creation

sunny_talwar — Wed, 27 Jul 2016 10:17:25 GMT

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

Re: Request help on dynamic table creation

Anonymous — Wed, 27 Jul 2016 10:21:59 GMT

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

Re: Request help on dynamic table creation

sunny_talwar — Wed, 27 Jul 2016 13:30:17 GMT

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