Replicate Excel table in QlikView

[brf10043]

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]

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

Thanks,

Pooja

[dapostolopoylos]

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

Check out this link: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Using_the_Pivot_Table.htm

[jyothish8807 · Accepted solution]

Hi Bobby,

Please refer the attached.

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

Br,

KC