topic Re: Multiple Fields in a single column in Straight table in QlikView

Multiple Fields in a single column in Straight table

AH — Sun, 25 Nov 2018 05:04:03 GMT

Hi,

Is it possible to make a straight table using multiple columns in a single field like mentioned in the attached excel file?

ABC, XYZ and PQRS are three different dimensions and lets say, for example, i am trying to get the sum of sales for each dimension values.

Thanks,

Anil_Babu_Samineni — Sun, 25 Nov 2018 13:04:26 GMT

Not sure, I understand the requirement. can you explain little more?

AH — Sun, 25 Nov 2018 18:10:12 GMT

Please find the new attachment. I changed the sample data for better understanding and explain the requirement a bit more.

Thanks for your response.

Regards,

Anil_Babu_Samineni — Mon, 26 Nov 2018 03:46:27 GMT

Understood !!

Not sure, How ABC sales will equivalent to "Sum of All Code Sales where XYZ.1 and XYZ.2 is equl to N", why this statement as this?

AH — Mon, 26 Nov 2018 12:45:31 GMT

Hi Loveisfail,

This is how the data is and requirement is laid out.

Thanks,