Discussion Board for collaboration related to QlikView App Development.
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.
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
View solution in original post
The attached sample is empty. Can you repost the document with data in it
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?