topic Re: Creating basic if statement expression in chart in QlikView

Creating basic if statement expression in chart

Tue, 22 Oct 2013 17:28:25 GMT

I am very new to Qlikview and have a basic chart of containing timesheet data.

I would like to break out into separate columns a series of paycode values with associated hours by testing with an IF statement for a particular paycode and return the hours for that paycode.

I completely understand the normal construct for an IF statement, but just cannot get the syntax correct in my chart.

Any help would be appreciated.

alathwell

Re: Creating basic if statement expression in chart

Gysbert_Wassenaar — Tue, 22 Oct 2013 18:24:18 GMT

Perhaps using a pivot table is an option. Add paycode as dimension and drag it to the right above the expression(s). Once you see a thick blue horizontal line you can let go and the paycode values should be shown horizontally as columns.

If you want to restrict that dimension to specific value you can use a listbox and select the values. Or you can use a calculated dimension like =match(paycode,'value1','value2',....,'valueN'). Or put the filter in the expression. Sum(hours) would become sum({<paycode={'value1','value2',..,'valueN'}>}hours).

Re: Creating basic if statement expression in chart

israrkhan — Tue, 22 Oct 2013 18:36:39 GMT

not clear to me,

if you want to break a value in to multiple value, you can use Left(), right(); mid() functions..

or kindly elaborate a bit more, show us the data...

Re: Creating basic if statement expression in chart

Clever_Anjos — Tue, 22 Oct 2013 19:25:23 GMT

Maybe you can use Set Analysis to separate

Column1 = sum({<paycode={"001"}>}hours)

Column2 = sum({<paycode={"002"}>}hours)

and so on

Set Analysis is usualy a better approach then 'if´s'