topic Re: Different columns in table every month in QlikView

Different columns in table every month

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

Hi Guys

I've got a table with the following columns ID, Subject , Q1, Q2, Q3, Q4

That's fine, so I'm building charts with the data from Q1, to Q4.

How can I automate next month, as I've done textbox expressions and charts for Q1 - 4, how can I automate the new columns Q5 with the expression and charts, charts and text boxes can be the same layout, I just need to populate an expression or table with the amount of Q I get each month, some can be 3 some can be 30 etc. And the questions will not be q1, q2, q3 etc, they will be random text.

Is this possible? crosstables and pivot tables perhaps?

Thanks

Re: Different columns in table every month

muthukumar77 — Thu, 29 Sep 2016 11:31:08 GMT

Hi,

Can you share sample data?

Re: Different columns in table every month

Anonymous — Thu, 29 Sep 2016 11:36:46 GMT

data in excel

Re: Different columns in table every month

muthukumar77 — Thu, 29 Sep 2016 11:43:00 GMT

Hi,

Send data in excel.

Re: Different columns in table every month

Anil_Babu_Samineni — Thu, 29 Sep 2016 11:43:45 GMT

I am not sure I understand your requirement might be this

'Q' & ceil(month(datefield)/3) + rowno() as quarter

Re: Different columns in table every month

Anonymous — Thu, 29 Sep 2016 11:51:38 GMT

Sorry Anil, you are totally doing something else. see excel file.