topic Re: Replicate Excel table in QlikView in QlikView

Replicate Excel table in QlikView

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

I'm now struggling to replicate an Excel table in QlikView..

I am trying to replicate this Excel table. In my chart the Date and Category is the dimension and the count is the expression.

Here is what I have so far in the table work. Any Ideas how to format a table like the one above from Excel?

pooja_prabhu_n — Tue, 19 Jun 2018 10:28:28 GMT

If possible could you please post some sample data and the app

Thanks,

Pooja

dapostolopoylos — Tue, 19 Jun 2018 10:33:58 GMT

You can use a pivot table and by drag and drop, position the time dimension on top of the count expression.

jyothish8807 — Tue, 19 Jun 2018 11:56:09 GMT

Hi Bobby,

Please refer the attached.

I have used a pivot table, you can drag your 2nd dimension and put it on top.

Br,